# Comparison of two cell with smartsheet

Options

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.

• Options

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 :) :)

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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"))

• ✭✭✭✭✭✭
Options

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?

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Ok i'm checking that in a minute :)

• Options

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"))))

• Options

thank you so much again !!

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!