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

12/26/18 Edited 12/09/19

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([email protected]:[email protected] = 0, "Not Started", "In Progress")

preview1.PNG

Popular Tags:

Comments

Sign In or Register to comment.