Comparison of two cell with smartsheet

Michael ROBASTON

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

Andrée Starå

Hi Michael,

Try something like this.

=IF(OR(ISBLANK(Baudouin@row); ISBLANK(Weichai@row)); ""; IF(AND(Baudouin@row = "Green"; Weichai@row = "Green"); "True"; "False"))

The same version but with the below changes for your and others convenience.

=IF(OR(ISBLANK(Baudouin@row), ISBLANK(Weichai@row)), "", IF(AND(Baudouin@row = "Green", Weichai@row = "Green"), "True", "False"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Hi Michael,

Try something like this.

=IF(OR(ISBLANK(Baudouin@row); ISBLANK(Weichai@row)); ""; IF(AND(Baudouin@row = "Green"; Weichai@row = "Green"); "True"; "False"))

The same version but with the below changes for your and others convenience.

=IF(OR(ISBLANK(Baudouin@row), ISBLANK(Weichai@row)), "", IF(AND(Baudouin@row = "Green", Weichai@row = "Green"), "True", "False"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Michael ROBASTON

Hello Andrée

It's working like a charm thank you so much.

Congratulations you are a boss.

Thank you so much

Have a nice weekend to :) :)

Andrée Starå

Excellent! 

Happy to help!

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Michael ROBASTON

So if i want to add more comaprison conditions shouldi go like this ?

=IF(OR(ISBLANK(Baudouin@row); ISBLANK(Weichai@row)); ""; IF(AND(Baudouin@row = "Yes"; Weichai@row = "yes") (Baudouin@row = "No"; Weichai@row = "No") (Baudouin@row = "Hold"; Weichai@row = "Hold"); "True"; "False"))

Andrée Starå

Do you always want it to show as true if both columns are the same except for when they are blank?

Then you should use this formula.

=IF(OR(ISBLANK(Baudouin@row); ISBLANK(Weichai@row)); ""; IF(Baudouin@row = Weichai@row; "True"; "False"))

If you want to have different answers for each control against the Yes, No and Hold critera you should use something like this. (Each IF is separated and will check until true)

=IF(OR(ISBLANK(Baudouin@row); ISBLANK(Weichai@row)); ""; IF(AND(Baudouin@row = "Yes"; Weichai@row = "Yes"); "Yes"; IF(AND(Baudouin@row = "No"; Weichai@row = "No"); "No"; IF(AND(Baudouin@row = "Hold"; Weichai@row = "Hold"); "Hold"; "False"))))

Make sense?

Michael ROBASTON

Ok i'm checking that in a minute :)

Michael ROBASTON

OK now its perfect

Here is the final version

=IF(OR(ISBLANK(Baudouin@row); ISBLANK(Weichai@row)); ""; IF(AND(Baudouin@row = "Yes"; Weichai@row = "Yes"); "Same"; IF(AND(Baudouin@row = "No"; Weichai@row = "No"); "Same"; IF(AND(Baudouin@row = "Hold"; Weichai@row = "Hold"); "Same"; "Different"))))

Michael ROBASTON

thank you so much again !!

Andrée Starå

Excellent! 

Happy to help!