Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
reminder to change oil after 5000 miles with multiple vehicles on the same sheet
I have a spreadsheet for truck maintenance on my vehicle fleet of about 15 vehicles, and I am trying to figure out a formula or some way to send a reminder email if the truck has accumulated 5000 miles since it's last oil change. I have columns for the date, the truck I.D., a checkbox for if the oil was changed that day, and mileage.
Any ideas?
Comments
-
Hi Joseph,
Instead of having a checkbox, you might consider having another text/number column that has "mileage since at last oil change."
Then use your other text/number column with the current mileage as something you could update periodically. You might even consider sending update requests to your drivers to get them to update the current mileage: https://help.smartsheet.com/articles/504779-using-update-requests
You could then have a third column with a flag or checkbox, and put an IF statement in it that takes the difference between "current mileage" and "mileage at last oil change" and checks/flags when that is greater than or equal to 5000.
You could then create a notification rule that sends you an email when the "needs oil change?" box is checked.
I've got screenshots of this below.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives