How do I create a flag that looks for Not Started and Today's date greater than begin

Paul Spickard

=IF(AND(Status8 = "Not Started", TODAY() > Begin8, 1, 0)

I receive an incorrect argument set

Andrée Starå

Hi Paul,

Try something like this.

=IF(ISBLANK(Begin@row); ""; IF(AND(Status@row = "Not Started"; Begin@row < TODAY()); 1; 0))

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

=IF(ISBLANK(Begin@row), "", IF(AND(Status@row = "Not Started", Begin@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?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!