Highlight Cells based on time stamp
Answers
-
If you're using the two System Created columns, you can subtract one cell from the other to find out the difference between the two:
=Modified@row - Created@row
This difference will include time, meaning that if the number is greater than 0.01, the Modified date column is more than 15 minutes older than the Created date. Then you can set up a Conditional Formatting rule based on your formula column:
An alternative would be to use the Highlight Changes feature built into the sheet. (See: Highlight Changes Made to a Sheet)
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!