Setting Up If Statement with 3 Parts

Kc185214

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?

Adam Murphy

Try something like

=IF(ISBLANK(Comments@row), "Not Started", IF(ISBLANK([Date Closed]@row), "In Progress", "Completed"))

Adam Murphy

Try something like

=IF(ISBLANK(Comments@row), "Not Started", IF(ISBLANK([Date Closed]@row), "In Progress", "Completed"))

Kc185214

That worked! Thank you for your help, Adam!