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


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"))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!