Sign in to join the conversation:
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.
Thanks,
Nick
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
Hi, I have been struggling for awhile that the contact list in a sheet, including automation, doesn't sync with My Smartsheet Contact list…how do I edit the contact list in a sheet? TY
My company is new to Smartsheet - we have been using it for about 2 months. The person who initially set it all up for us has since left the company and his account has been deleted from smartsheet. However as his name is still present at the top of the workspaces I guess that means he is still the listed owner of the…
Hi All I have created a support request form and sheet to allow functions to request support from my team. When a request comes in, it is assigned a unique support ID number. I then assign the request to a member of the team vias drop down. I have added an automation to message the requester when a team member has been…