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.
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.
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Hi - We number tasks in our Smartsheet grid using the format XXX.X. When we sort in descending order, the numbers are not in order. For example 200.0 appears below 001.0. Since it is in descending order 200.0 should appear before 001.0. We also want to start using four digits before the decimal point and want to know if…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.