How to add a date based on a checkbox
Hi,
I am trying to put a formula into a cell to say that if a check box is checked, put in the date that box was checked. I was able to do this before but it is no longer working. Is there still a way to do this?
Thanks.
Comments
-
Hi,
You can have a formula that adds today's date, but the problem is that the TODAY function will update to the current date always so it will not store the date. You'd either have to add it manually, use a third-party solution like Zapier, the Smartsheet API, or create a workaround like locking the row and similar.
Would any of those methods work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
-
Can you explain the work around more with locking the row?
-
Sure!
If we use the automation and lock the row after the box gets checked, the Modified Date column would then fix on the date/time from that event but this only works, if there aren't any more changes, are needed for the row.
Make sense?
One other method, but it's more advanced, would be to use the third-party service, Zapier, to add the date to another column for when the box gets checked. Is that an option?
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives