If Contains Statement

I am trying to say If x column contains (a) value then display (b) value from another sheet. But it says Invalid Data Type

=IF({Retained Team Look Up Table Range 1}, CONTAINS(Resource@row, @cell), {Retained Team Look Up Table Range 2})

Retained Team Look Up Table Range 1 has the same values as in the Resource column of the grid I am in. If that matches I want it to display the value shown in the Retained Team Look Up Table Range 2.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!