HELP with IF formula and cell reference

mtaekla

I would like to check cell [Actual Finish Date}4 for a date before executing =IF(ISBLANK([Planned Finish Date]4), 0, IF([Planned Finish Date]4 < TODAY(), 1, 0)) which sets a FLAG to true. If [Actual Finish Date}4 has a date then set FLAG to false. If there is no date then execute on the above formula.

Andrée Starå

Hi,

Try something like this.

=IF(NOT(ISDATE([Actual Finish Date]@row)); IF(ISBLANK([Planned Finish Date]@row); 0; IF([Planned Finish Date]@row < TODAY(); 1; 0)))

The same version but with the below changes for your and others convenience.

=IF(NOT(ISDATE([Actual Finish Date]@row)), IF(ISBLANK([Planned Finish Date]@row), 0, IF([Planned Finish Date]@row < TODAY(), 1, 0)))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

mtaekla

Thank you very much, that works perfectly! I am US based and the 2nd version did the trick. Have a wonderful week.

Andrée Starå

Excellent!

Happy to help!