Use Case Examples - Asset Management: how to display a warning for next service date on equipment

This use case example means that a warning will be displayed when the next service date is nearing. You can set the number of days a warning (service warning, days) would be displayed, for example: If the next service date is in the next 14 days, a warning "Service due soon" will be displayed in the row.

To start, you can use either a default or prefilled table by navigating your cursor to the left tab and choosing either under the 'Table'. Set your table as required, but usually the table should closely look like this:

Table 1 Equipment Log (Default table)

Equipment	Last Service Date	Service Interval	Next Service Date	Service Warning (7 days)
(Dropdown list) - A1	(Date field) - B1	(Number field, in days) - C1	(Formula field)	(Formula field)

Use the formula,

Next Service Date:

=Text(B1 + C1, "DD/MM/YYYY")

Note: Take note of the date text if it is consistent with the Date field for the 'Last Service Date'

Warning:

=IF(B1+C1 - TODAY() <= 7, "Service Due Soon", "")

Note: Service Warning is the number of days before the service due when the warning will be displayed. You can change this value depending on company guidelines.