Comparison of two cell with smartsheet


Hi community

I'm trying to do something pretty easy but couldn't go further on my own.

I have one column where users from one site will answer in every cells "Yes, maybe, no" through a 3 choices list (column Baudouin) that shows symbols (green square ,orange square , red square) depending of the answer

And another column do the same for another site, colmumn Weichai.

I just want on another column to do comparison of the answer, if both answer are green i have true if they are different i have false.

Many thanks for your help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!