How do we create CASE statements in Smartsheet by Multiple IF statements?

molson

I'm having an UNPARSEABLE error when trying to createa a formula to get a "30 Days" category from a field which used to be "free-form" and recently just became a dropdown. Hence I get "30 Days" or "30 days" in the field. Below is the formula, what is causing the error?

=IF(CONTAINS("30 Days",[Business Retention],1),"30 Days",

IF(CONTAINS("30 Days",[Business Retention - Other],1),"30 Days",

IF(CONTAINS("30 days",[Business Retention],1),"30 Days",

IF(CONTAINS("30 days",[Business Retention - Other],1),"30 Days", "Others"))))

DKazatsky2

Hi @molson ,

Try putting "@row" after the column names and see if that helps. So each would look like this - "[Business Retention]@row" as an example.

Hope that helps,

Dave

molson

Thank you Dave! The @row worked together with removing the ",1" inside the CONTAINS arguments.