Get the days used to finish a task

Hello good afternoon. I use the timeline component to determine the duration of a task. This element contains the start and end date of the activity, and when the value of the task status is changed to finished, the timeline indicates the number of days it took to finish the activity (hover). How can I get that value in a column in the dashboard?

@Edison

You can use a formula column to do that. Something like:
DAYS({Timeline#End}, {Timeline#Start})

A second alternative is the timeline + numeric column combo:


Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating subitems using Make/Integromat The Monday Man (EASY) Way
Contact me directly here: Contact – The Monday Man

Hi friend! thanks for you answer.

What I need is the value of the message that comes out above the schedule, regardless of whether the status of the activity is changed: for example:

If the activity is late, this message appears:
atrasada

If the activity is in process, this message appears:
en plazo

If the activity finished on time, this message appears:
listo plazo

If the activity finished after the deadline, it shows this message:
listo fuera plazo

The message always appears when hovering over the timeline. Said message is that I need to capture.

Thanks!

@Edison

It is also possible to “create” that text. But depending on how you want to use in your dashboard, it may not give you what you want and it would be more work.

To create the value, you would need to create a date column that would be set via an automation when the status is changed to “Finalizado”.

Then, you would need to construct a formula using the new completion date, t


Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating subitems using Make/Integromat The Monday Man (EASY) Way
Contact me directly here: Contact – The Monday Man he timeline end date and the status column to create the text message you want.