Timelines: Time range with no specific dates

[dnieto]

Hello!

I'm trying to organize a set of tasks that start from "two weeks ahead" of an event. Using fields such as duration or date will have me pick a specific date/time for which I don't have information. I just need those set of tasks to show "this lasts 2 weeks", or "prepare 1 week in advance" and I'm not sure how could I accomplish this using a timeline (I like the visuals that offer). 

Any ideas are appreciated! 

[Stephen_Orr1 · Accepted solution]

Hi @dnieto,

It's a bit custom but you can achieve something like this with the help of few extra fields:

• a linked record field - pointed at the same table to choose predecessor events
• a lookup field - to display the start date of a predecessor event
• a single-select dropdown - to hold date manipulation options like "as-is", "2 weeks later", "1 week earlier" etc.
• a formula field - to add/subtract days from the predecessor event's start date based on the dropdown field's value

Then you could use this formula field as a start date in the timeline view and quickly adjust the relative date options via the single-select dropdown field all from within the same timeline view.

Also, you might take a look at the Gantt view for tracking dependent events. If you set up dependencies (a linked record field pointed to the same table it's in) in your Events table, then you can turn on dependencies in the Gantt view and drag the bounds of records to affect the dates of dependent events by date rippling.

Hope that helps!
-Stephen 

[dnieto]

Hi, Stephen! 

That's something I can do! I'll try and see how it goes