Question

I created a column "Past Due" and I want to plug a formula in it to determine if a subtask is past due with a "Yes" or a "No". My IF/THEN statement produces an "Invalid Data Type". Here is the statement: =IF(AND(Finish:Finish, "Complete", Health:Health, <>""), "Yes", "No") Finish is a date. I only want the Yes or No to appear on subtasks. That is why I included Health:Health<>"". In the main task Health will always be blank. I would like to make this a column formula.

DKazatsky2 · Accepted Answer

Hi @PMOGal, Try doing it at the row level and see if that gets what you want. =IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "No") Hope this helps, Dave

PMOGal · Accepted Answer

That works!  Thank you.