Check box to get unchecked.

Rajeev84
Rajeev84
edited 12/09/19 in Smartsheet Basics

Hi All,

I want when the date changed in by my sheet, the check box that were already applied should automatically removed.

Is there any any formula that I need to put in.

If anyone can help will be great.

Comments

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

    Hi Rajeev,

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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 for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Hi Andrea,

     

    There are certain activities which each team member has to do every day.These team members receive notification from smartsheet about the activities planned for that day in format of Smartsheet form.Once they mark it as done, the check  box gets updated.But next day, i.e on change of a date this check box should automatically get removed.

     

    Please see the attached screen shot.

    smartssheet.PNG

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

    Try this.

    If Done in your sheet is the column that the Team Member checks of and the one that you would like to get unchecked automatically it's not possible because as soon as you change a cell manually, the formula will be replaced.

    My suggestion would be to add a helper column named Team Member Done (Checkbox) and let the Team Member check it off when done and then in the Done column you would add the formula below.

    The sheet has to be opened daily because otherwise, the TODAY formula won't update. It's possible to automate it with the help of a third-party tool like Zapier or similar.

    This formula will check if the date is today and if the Team Member Done is checked.

    =IF(AND([Day column]@row = TODAY(); [Team Member Done]@row = 1); 1; 0)    

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

    =IF(AND([Day column]@row = TODAY(), [Team Member Done]@row = 1), 1, 0)

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Would that work?

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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 for help with Smartsheet, integrations, general workflow advice, or anything else.

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

    Hi Rajeev,

    How did it go? Did you get something set up?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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 for help with Smartsheet, integrations, general workflow advice, or anything else.