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?
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:
If the activity is in process, this message appears:
If the activity finished on time, this message appears:
If the activity finished after the deadline, it shows this message:
The message always appears when hovering over the timeline. Said message is that I need to capture.
Thanks!
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.
Hi @Edison @JCorrell and everybody who is looking for solution 
Welcome to the community!
For get the days used to finish a task i reccommend you to try Time in Status app which helps to track time the Item has spent in each workflow status.
You’ll get user-friendly data on the board in a few seconds.
Also you will be able to track how much time your issue spends in each status and much more by generating:
And use charts to visualize your reports a sample of a certain number according to time range/item range, or a single item:
- Pie Charts
- Bar Charts
- Area Charts
The app is also available in the format of board integration.
Start the 14-days free trial to try it out for yourself and share your experience with us.
Hope you find this app helpful,
Valeriia