Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Trying to connect a check box column to a completion date column
Comments
-
There may be other solutions, but I have found that using a hidden "Modified (Date)" column in combination with an IF formula gets the job done. If you want it to populate in your "Completion Date" column, use IF([Check Box]= 1, [Modified], "") . This only works if checking the box is the last thing you change though.
-
You would have to manually lock the row from additional edits, or else the Modified date will continue to go forward in time
-
Hello Nate,
Using the Modified Date column, and possibly an IF formula to populate the Completion Date field would work, but as Jeff mentioned, this process will only work if marking the task Complete is the last edit that is made on that row. If another change is made on that row it will cause the Modified Date field to change causing the Completion Date to change as well.
If other changes will be made on the row there wouldn't be a way to accurately report when a specific cell has been changed. You can right click on a cell to see the date/timestamp on when the cell was edited, but you can't pull that information into another cell. I'll be sure to add a vote for a timestamp formula to our enhancement request list.
-Zack
-
Nate and group,
This exact problem can be solved using Azuqua, an integration partner of Smartsheet. I work for Azuqua and the logging timestamp in a column based on a checkbox being marked (checked) is one of the many scenarios that we enable inside of Smartsheet.
Using Azuqua you can set up a monitor for a change to column and in your particular case check to make sure the checkbox has been marked and then confirming the checkbox has been marked a timestamp / date will be entered into the column you specify.
With this solution you do not need to worry about dates being overwritten, which is one of the concerns from this particular discussion.
If you want to learn more please visit our app listing at Smartsheet here:
https://www.smartsheet.com/apps/azuqua
Please feel free to follow up with any questions.
-Patrick -
I would also like this exact functionality.
-
Can I add another vote for this functionality. Would love to be able to check a box and have a formula that auto fills the date. Something like =IF([CB1] = 1,GETDATE(),"")
-
Another vote for this functionality. Thanks.
-
Another vote for this enhancement! Thanks!
-
Searching for the enhancement request for this feature - desired to trigger email notification of action required (using Reminders)
-
I do this now using Zapier (www.zapier.com)
I have a Zap that watches for an empty date column and a completion check box - when the check box is checked by the user, today's date is entered into the date column.
Later, if someone makes another change elsewhere in the row, which triggers the Zap, it does not do anything because the date column is not empty.
Craig
-
Same here! Would love it!!!!
-
My solution using Zapier is posted here:
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
Craig
-
Hi,
I am just in SmartSheet, no Zapier, no other thhings.
For the same problem as you ... I finally just do it the other way round.
I have the to columns as you (done and completion date).
I enter the completion date (just enter t is enough to enter todays date) and I have inserted a formula in the 'done' checkbox column (IF(completion date = "", 0,1)
That works 'good enough' :-)
Cheers
Bruno
-
Hi Craig, I saw your comment (above) about a zap that watches for an empty date column on Smartsheet and then enters a date. Can you let me know how you managed to do this - I've been using Zapier but for some reason can only find triggers that are related to wholesale changes (new row/comment/attachment or updated row) as opposed to being able to narrow it down to one column.
It would be awesome if I can replicate what you have done.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives