Conditional Formatting when changes are made
How do you highlight when a change is made to any row or column? e.g. if someone changes the due date, I want the entire row to be a color.
Comments
-
Hello Leann! You cannot do this automatically if a change is made in a row, to be colored. But, there is a feature built-in that does this!
Check this image out here:
Do you see the marker next to the table and hyperlink buttons? That is called a highlight change. It will highlight any cell that has been changed since you last looked at the sheet.
Thanks,
Nick
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
-
Hi Leann,
To add to Nicks excellent advice for the Highlight Changes.
It's possible to to have a row change color when the due date changes but the date have to be set either in another column or in the Conditional Formatting rule.
Would that work?
Let me know if you have any questions!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives