I want to calculate a duration for specific items and their dates. I have a date column and I want to calculate the duration between a specific items for that date column… So it’s kind of creating a timeline column for specific items and then calculating the duration of that column… here is what I have (Board_Dur)… and this is what I’ve started on doing (formula___if({Name}=“Engagement Kickoff”,{BaseLine Date},if({Name}=“Report Sent to Client”,{BaseLine Date},“”),“”) which gives me this (Calc_Dur)
So the question is how to create a timeline column based on a date column and per specific items. Thanks