IF Statement - Checkboxes

IF Statement - Checkboxes

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), [email protected] = "In Progress"), 1, 0)


Thanks!

Mahshad

Best Answer

Answers

  • Andrée Starå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), [email protected] = "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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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

  • Try

    =IF(ISBLANK([End Date]@row), 0,IF(AND([End Date]@row <= TODAY(30), [email protected] = "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


    ✅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!

Sign In or Register to comment.