IF Text in any field between multiple columns, then equals text value

codynew
codynew
edited 12/09/19 in Formulas and Functions

I am having some issues using the "IF" formula. I'm trying to make it so if ANY VALUE is in the "CUT, FAB, WELD" columns then it will output the text "In Progress" to the "STATUS" Column, and if there is no value in any of the columns then the "STATUS" column will say "Not Started". Along with this, I have a checkbox in the "COMPLETE" Column, and if that is checked then I would like the status to say "Complete" I've tried multiple different formulas but i cant seem to get it.

Sheet

=IF(CUT@row:WELD@row = 0, "Not Started", "In Progress")

preview1.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!