How to capture the date that a checkbox is checked & record it in another column automatically
Is there a way to capture the date that a checkbox is checked & record it in another column automatically? The timestamp lives in the cell history for the checkbox, but not sure how to pull that out into another column so we can then use that info for formulas, etc. Let me know if you have any ideas.
Answers
-
You would need to use a third party app such as Zapier or the API.
The only other option for this would be to use a Copy Row automation to pull the row data to another sheet and lock in that time/date stamp then use a formula with a cross sheet reference to pull that "frozen" time/date stamp back onto your main sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Another way to do it is to create an automation workflow to Record a Date based on when the Checkbox is checked/unchecked.
-
@Hakim Azly Yes. Now that we have this automation we can use that. Prior to the automation though we would have to use the copy row automation and then some cross sheet references.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I tried this automation but is it adding the date to EVERY row on the sheet, is there a way to make it only record the date on the row the box is checked? thank you in advance!
-
@vbron If you are using the "Run Now" feature, it ignores the trigger and only evaluates conditions. Since you have no condition, it will apply to every row. To use the "Run Now" feature, you would need to build in a condition that says where Completed is Checked.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives