Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Timeline Utilization using 2 dates (start date and end date)

Topic Labels: Formulas
80 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello all, thank you so much for taking the time to read this, any help would be appreciated

I have a question with regards to a topic that Gareth covered in is "“Allocating Resources with a Timeline View”.

His demonstration is great, however the utilization field in the timeline only links to a single record, which is fine if you only take 1 day off at a time. My records need to have both a start and end, some up to a week apart.

My question, is there a formula, or other method that will allow to be take both of these dates and consolidate all of the dates in between into a single cell? As this seems to be the only way for the timeline to recognize all of my holidays

image

If there is a better solution for me to do this then any help is appreciated, but essentially the end goal is to find a way to combined projects and holiday data (2 dates) onto one timeline

Thanks !

0 Replies 0