Formula Quesiton

Melita Clark

I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets ( since I haven't figured out a way to do it with conditional formatting)?

=IF([Desired Engagement]@row = Engagement@row, "Do Nothing", "Yellow")

Thanks in advance!

Andrée Starå

Hi @Melita Clark

Try something like this. (in a checkbox column)

=IF([Desired Engagement]@row = "", "", IF([Desired Engagement]@row = Engagement@row, 1))

Did 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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Melita Clark

Try something like this. (in a checkbox column)

=IF([Desired Engagement]@row = "", "", IF([Desired Engagement]@row = Engagement@row, 1))

Did 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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Melita Clark

@Andrée Starå this worked perfectly! Thank you!

Andrée Starå

@Melita Clark

Excellent!

You're more than welcome!