How to create a column that automatically records when task is done

Platform discussions
1

Is there a feature that automatically adds the date something is actually marked as done?

2

@lizknuppel

Yes.

Try this automation:
image

Jim - Subscribe to The Monday Man
Watch Our Latest Video: POWERFUL Item/Subitem Templates

3

Thank you, but what if I want to see the delta between when it was scheduled and when it was completed?

Thanks,

Liz

4

Hi @lizknuppel!

For that you need to create an automation that automatically sets the date for when a new item is created. With this and using Jim’s solution you can have both start and end date set automatically. Finally, with the formula column you can count the days passed between each of the dates and get the delta you’re searching for.

Hope this helps :wave:

5

@lizknuppel

Ana is correct.

The formula for days late would be either:

DAYS({Completion Date}, {Due Date})

OR…

WORKDAYS({Completion Date}, {Due Date})

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas - Part 2: Expert Tips And Tricks

6

Thank you both. Looking forward to putting this into practice.

Liz