Auto Checkbox

08/05/20
Answered - Pending Review

I would like a formula to check a box for open cases. I have a start date column and an end date column. Only check the box when there is a start date and no end date entered. Thank you!

Popular Tags:

Answers

  • SoS | Dan PalencharSoS | Dan Palenchar ✭✭✭✭✭

    Use this in the checkbox column

    =IF(ISDATE([End Date]@row), 0, IF(ISDATE([Start Date]@row), 1, 0))



  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Another option would be to use:

    =IF(AND([Start Date]@row <> "", [End Date]@row = "", 1)

  • Thank you for your help!

  • I am trying to get a box checked when a date appears in another column. The column header is "Cut Date" and the Checkbox column header is "Order Cut"

    =IF(DATE([Cut Date]@row), 1) and it is not working. Any suggestions?


    Thanks.

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

    Hi @Sarah_lee123

    Try this. (You’d use ISDATE instead)

    =IF(ISDATE([Cut Date]@row), 1)
    

    Did that work?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

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

    Did my post(s) 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 PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.