IF Statement - Checkboxes

Options
Mahshad Farmanbar
Mahshad Farmanbar ✭✭
in Formulas and Functions

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

Tags:
· Share on FacebookShare on Twitter

Best Answer

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

    · Share on FacebookShare on Twitter
  • Mahshad Farmanbar
    Mahshad Farmanbar ✭✭
    Options

    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

    · Share on FacebookShare on Twitter
  • Frank Falco
    Frank Falco ✭✭✭✭✭✭
    Options

    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


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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!