IF Statement - Checkboxes

Mahshad Farmanbar

Hi there,

I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field is left blank and the Status is "In Progress" the checkbox is marked off. I want to make it so if the End Date is blank there is no check mark. What is the best way to go about this?

Formula: =IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0)

Thanks!

Mahshad

Andrée Starå

Happy to help!

I missed a ). Sorry about that!

Try this one instead.

=IF(ISBLANK([End Date]@row), 0, IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0))

Andrée Starå

Hi Mahshad,

The best way would be to add an ISBLANK function in the start of the formula.

Something like this.

=IF(ISBLANK([End Date]@row, "",IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0)

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or 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!

Mahshad Farmanbar

Hi @Andrée Starå

Unfortunately it did not work. It says invalid argument. Do you know what the issue may be?

Thanks so much for your help! :)

Mahshad

Andrée Starå

Happy to help!

I missed a ). Sorry about that!

Try this one instead.

=IF(ISBLANK([End Date]@row), 0, IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0))

Frank Falco

Try

=IF(ISBLANK([End Date]@row), 0,IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0))

Need to return 0 if [End Date] is blank and then evaluate the original date and Status formula returning 1 if true