Record date the box is checked
Is there a formula that records the date when the checkbox is checked? I need to track this and right now I just do it manually by right clicking in the cell to see when it was edited. But it would be awesome if I could create a formula to show me when that box was checked automatically.
Best Answer
-
You would need to use either the API or a 3rd party app such as Zapier. There is currently no way to access the cell history or timestamp a specific action (other than row creation). You could always Submit A Product Enhancement Request.
Answers
-
You would need to use either the API or a 3rd party app such as Zapier. There is currently no way to access the cell history or timestamp a specific action (other than row creation). You could always Submit A Product Enhancement Request.
-
Hi,
Smartsheet is working on it.
As Paul mentioned. The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?
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.
-
-
@Aubrey K. Rawson Smartsheet has since released the Record A Date Automation. That should do the trick for you if you are just needing to capture the date a specific action happens.
-
I hope you're well and safe!
To add to Paul's excellent advice/answer.
This might also be helpful.
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
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 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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!