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
Is anyone a SmartSheets pro that could get on a call with me for no longer than an hour and go over some basics (to you I'm sure) on how this system works? My Launch10 package was used mostly to set up my first sheet and I never had the time to actually learn how to use the system. I have automations set up but there are…
Hi all! I just noticed the new "Filter" feature on dashboards, but I cannot find any resources for additional support yet. So far I can only get it to connect to report widgets — does anyone know if you are able to use this filter feature with chart widgets? Use case: I have a line graph that shows various class offerings…
I am wanting to share content that has a default filter applied where it only pulls specific rows (leveraging "Current User") filter. Originally, I had tried leveraging a report, however, that does not allow the user to be able to add rows and self assign (unless experiencing user-error). Having a report is my preferred…
