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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!