Formula to check the cell for 4-5 text strings

I have a condition where in the formula should check the text in CELL A and return value based on the assigned values and should leave the formula cell BLANK if none of the condition is satisfied.

I tried it through spreadsheet and the formula is:

IF(OR(A1= "Name A", A1="Name B",A1="Name C",A1="Name D",A1="Name E",A1="Name F"),"XYZ","ABC").

when I am converting this to Smartsheet formula, it is coming as #UNPARSEABLE:

IF(OR(CELL1@row= “NAME A”, CELL1@row = ”NAME B”, CELL1@row=”NAME C”, CELL1@row=”NAME C”, CELL1@row =”NAME D”, CELL1@row=”NAME E”,"XYZ”,"ABC").

I would appreciate a quick response 🙂

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!