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.
Update End Column When complete is mark
Comments
-
For clarity, are you asking if the end date would be able to populate the date that the checkbox is marked off for project complete?
-
Yeap
We mark with a check box on a complete columneverytime we finish a task.....and we will like the end date to populate himself when the check box is mark.
Is there a way to do this?
-
It sounds like you're using the end date more as a marker rather than for scheduling purposes? I'm not sure of a clean way to do this, but if checking the completed box is the last thing someone does to that row, have you tried adding a "Auto-Number/System..." column to the end of the row? It will timestamp with the most recent row modification if you have it set to "Modified (Date)".
-
Yeah we are trying to use it more as a marker on end dates. But it dosent seems to work on smartsheet.
I just tried the options you gave me on using a modified column but no results on that.
thanks on your feedback
-
Pablo,
Try it again, but in order to see the time stamp, you must save and refresh. Hope this works!
-
Do be aware, however, that any other modifications to the row will affect that date. So if the project is truly complete, don't modify any fields in the row (at all) after that time or your modification date will change.
-
-
Craig,
That's great! To clarify, that requires a monthy subscription fee to Zapier? Thanks.
-
Matt,
You'll need at least the Business Plan because the solution uses multiple steps.
They have an annual subscription that gives a discount too.
Craig
-
Thanks J. Craig
This will work for our issue. And thanks everybody for the help.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives