See Timeline column in YEARS

Platform discussions
,
1

Hello again, is there any way to see timeline column in years? I want to use it to track a contract duration, that sometimes last 2 or 3 years. I don´t want to see it in days left, but yes in years.

Thanks a lot!

2

Hey Marcelo! While it is not possible to show years instead of days in the Timeline Column, you could absolutely do this with a Formula Column!

For the formula I would suggest a “format date” formula like the following:
FORMAT_DATE(DAYS({Timeline#End},{Timeline#Start}),“YY”)

Let me know if this helps!

3

For some reason it’s not working… Could please explain me how to apply this?
End and Start are commands? Or columns names? Also this converts a formula column in a timeline column?

Sorry, and thanks!