Setting up your table
To get started, navigate to Templates > Add Template > Browse free templates, or open an existing template in the Template Editor. Add a table to your form — your table should include the following columns:
Column | Field type |
Equipment | Dropdown list |
Last Service Date | Date field |
Service Interval | Number field (in days) |
Next Service Date | Formula field |
Service Warning | Formula field |
Adding the formulas
Next Service Date
In the Next Service Date formula field, enter:
=Text(B1 + C1, "DD/MM/YYYY")
Note: Make sure the date format matches the date format used in your Last Service Date field.
Service Warning
In the Service Warning formula field, enter:
=IF(B1+C1 - TODAY() <= 7, "Service Due Soon", "")
Note: The number 7 represents the number of days before the service due date when the warning will appear. Update this value to match your company's maintenance guidelines.
Using Storm AI Templates
You can use Storm to help build or adapt this table setup for your equipment tracking needs.
Open your template in the Template Editor and select Storm
Describe what you need, for example:
"Add a table to track equipment service dates, with a formula that calculates the next service date and displays a warning when it's due within 14 days"
💡 You can also use the voice recorder to describe your setup out loud instead of typing.
Review Storm's output before saving to make sure the formula fields are configured correctly.
FAQs
Can I change the number of days for the warning?
Yes — update the number in the Service Warning formula (e.g. replace 7 with 14) to match your company's preferred lead time.
Does the warning update automatically?
Yes. The formula uses TODAY() as a reference, so the warning status refreshes each time the form is opened or recalculated.
Can I use this setup for multiple pieces of equipment?
Yes — each row in the table represents one piece of equipment, so you can track as many assets as needed in a single table.
Can I use a different warning message?
Yes — replace "Service Due Soon" in the formula with any text you'd like to display, for example "Maintenance Required".