Ideas to track schedule maintenance

Ed Gadd

I'm curious for some inspiration please!

I'm using a form to log usage of machinery. This collects data on the time used in minutes, which I convert to hours and total for each machine. The machines need routine maintenance every 20, 200, 300 and 400 hours.

I'm looking for ideas on how I can use the total hours run for each machine to trigger the notification that maintenance is due when each threshold is met.

Once this triggers at each threshold I'll be able to set automations to change the status of the machine, the maintenance required and notify the persons who need to action the maintenance etc.

I'm sure this will be an easy request for someone. Many thanks in advance.

Paul Newcome

You can use a MOD function. If the MOD of a number is equal to zero, it is a multiple of that number.

=MOD([Hours Used]@row, 20)

would output zero on every multiple of 20 (20, 400, 60 , 80, …). You can use an IF statement to say that if the MOD is zero, then the 20 hour maintenance is due.

=IF(MOD([Hours Used]@row, 20) = 0, "20 Hour Maintenance Due")

Paul Newcome

You can use a MOD function. If the MOD of a number is equal to zero, it is a multiple of that number.

=MOD([Hours Used]@row, 20)

would output zero on every multiple of 20 (20, 400, 60 , 80, …). You can use an IF statement to say that if the MOD is zero, then the 20 hour maintenance is due.

=IF(MOD([Hours Used]@row, 20) = 0, "20 Hour Maintenance Due")

Ed Gadd

Hi @Paul Newcome, Great idea, I'll give that a try.

Many thanks.

Paul Newcome

Happy to help. 👍️