Where in this formula would I add in within 1000km
I use a smartsheet to track my fleet. When something meets this criteria it ticks the box and then an automation is activated.
I was wondering how I would change this so somewhere in the formula the km's were within 1000 or over the RUC amount. This way before it is overdue, it sends the email.
Here is my current formula and an image of my sheet: =IF(OR(AND(NOT(ISBLANK([Service Due Date]@row)), [Service Due Date]@row <= TODAY(14)), (AND(ISBLANK([Service Due KM's]@row), [Service Due KM's]@row < [Odometer Reading]@row))), true)
Help Article Resources
Check out the Formula Handbook template!