Setting a status based on date fields

Bianca Mitchell

Is there a way that I can update or set a status based on data in 3 other fields? What I am trying to do is set a status based on data being entered in 3 other fields - if those fields are blank, then status would be 'In Progress' if those fields contain data (dates or text) status is 'Complete'? Is this doable?

Mark Cronk

Hi Bianca,

You'll use nested IF statement with AND and OR. You'll need to add the right column names but your formula will be:

=IF(AND(ISDATE(start@row), ISDATE(end@row), ISDATE(mid@row)),"Complete", IF(OR(ISDATE(start@row), ISDATE(end@row), ISDATE(mid@row)), "In Progress", "Not Started"))

Mark