Due Dates
Hello everyone!
I am looking for way for due dates to update on their own.
We have daily, weekly, monthly tasks and it would be fantastic to have the due dates updated when a task is completed.
Thank you!
Best Answer
-
Hi @aemmel,
You could use the Record a Date" automation option to enter Today's date.
You could do this in an additional column for Completion date that uses the automation to enter today's date when the Status is updated to "Complete". Then you don't lose sight of when something was due, and can compare to when it was completed.
You could also do the same for your Due Date column, but you will lose sight into when something was due as opposed to when it was complete.
Hope this helps!
BRgds,
-Ray
Answers
-
Hi @aemmel,
You could use the Record a Date" automation option to enter Today's date.
You could do this in an additional column for Completion date that uses the automation to enter today's date when the Status is updated to "Complete". Then you don't lose sight of when something was due, and can compare to when it was completed.
You could also do the same for your Due Date column, but you will lose sight into when something was due as opposed to when it was complete.
Hope this helps!
BRgds,
-Ray
-
Hey @Ray Lindstrom!
Thank you for the information.
I am new to Smartsheets- could you provide the steps in a comment?
Thank you so much!
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