Formula to change row color if data has been changed

HarryS

Hello,

I have a row of data on a sheet, that contains three cells where users have been asked to note changes. Can anyone tell me a formula that I can use to make the row change colors (like red), when data in either of those cells have been changed? Or maybe another way to flag the row when something has been changed?

Thanks!

Andrée Starå

Hi @HarryS

I hope you're well and safe!

The easiest way would be the Highlight Changes feature.

https://help.smartsheet.com/articles/521974-highlight-changes-made-to-a-sheet

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

HarryS

Thanks for the quick response! Highlight Changes will definitely help in the interim. Thanks! I would ultimate like to have the entire row change colors, or maybe add a column where a flag can appear if one of the three cells have been changed. That way I can create a filter to view only the flagged rows.

Andrée Starå

@HarryS

Excellent!

Happy to help!

• It's possible to do what you want, but it's not as easy. My method below could be adapted to work, I think.

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

HarryS

Thanks for the info! I can't determine if the solution you linked to will assist me in what I am trying to accomplish, but will tinker with it to see if it can somehow help resolve my problem.

Andrée Starå

@HarryS

Excellent!

You're more than welcome!

I'd be happy to share an example. 

Please send me an email at [email protected], and I'll share it with you.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!