Setting Up If Statement with 3 Parts

edited 03/14/24 in Formulas and Functions

I have a status column where I want the 3 options to be "Not Started, Work in Progress, or Complete". The "Not Started" status would come from the Comments & Date Closed column being blank. The "Work in Progress" status would be based on there being comments added, but the Date Closed has not been filled in. The "Completed" status would need to come from the Date Closed column being filled in.

I have not been able to set up a formula that takes into account both columns and returns the correct status. Could someone help me with this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!