Formula for date when a box is checked

Options

I am trying to write a formula that will enter the date when a checkbox is checked. I have an automation set up but it needs to be updated every month so I thought I could write a simple formula to enter the date (approval date) when the box is checked by the approver


Tags:

Answers

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

    Hi @Chris K

    I hope you're well and safe!

    Not sure I follow! Can you elaborate?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.

  • Chris K
    Chris K ✭✭✭
    Options

    Each month I send a report to department managers to approve the hours their employees worked on a project that month. The manager will review the list and check the box for each row that they approve. I want to automatically capture the date of the approval (checked) in the next column. Currently, I have an automation that fills in the date column when the box of the same month is checked but the automation needs to be updated each month. I am hoping I can write a formula in the date column like =IF([April Manager Approval]@row =1, TODAY()) The problem with that formula is that the date changes to the day of viewing not the date of approval.

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

    @Chris K

    You could add multiple Workflows or Condition Paths that check the month and registers the date in the correct column.

    Would that work/help?

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!