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!

4

@Marcelo_BCN

Here’s a formula that will show years:

IF({Timeline#Start}, 
  ROUND(
    YEARFRAC({Timeline#Start}, {Timeline#End}),
  1),
"")

“Start” and “End” are column reference parameters. They cause the column reference to return only the Start date or End date, respectively, of the timeline column.

Jim - The Monday Man

5

Hello Jim, many thanks! The formula works, but it shows me the result in numbers, not in Timeline format. Is that possible? I already had my formula to show the year in a column.

Saludos!

6

@Marcelo_BCN

Can you give me an example of what you mean by timeline format? Do you mean IN the timeline column where it shows days? If so, there is currently no way to do that.

Jim - The Monday Man