Formula for date when a box is checked

Chris K

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

Andrée Starå

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!

Chris K

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å

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