IF Function for multiple values

Can someone please help me with the formula where if the column1 has any value from the list (i.e. test1, test2, test3, test4) the output should be "Test Result".

I tried this with the formula =IF([Column1]@row, = "Test1" + "Test2" + "Test3" + Test4","Test Result") but the output is coming #INVALID DATA TYPE

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!