Due Dates

aemmel

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!

Ray Lindstrom

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

Ray Lindstrom

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

aemmel

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!