Contains & "Invalid Column Value")



I am trying to use this formula:

=CONTAINS("Medium"; [Rank]:[Rank])

Rank column is the column with drop-down (single select) where user can select one of these:

High (Business Critical)

Medium (Moderate Need)

Low (Nice To Have)

However, it results in the "Invalid Column Value" error. Do you know how to solve this?

thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!