Forum Discussion
Gnatt chart template formula
=IFERROR(IF(LEN([@Tasks])=0,0,IF(AND('Chart Data'!$H6<=$B$12,'Chart Data'!$I6>=$B$12),ABS(OFFSET('Chart Data'!$H6,@ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart Data'!$K6,@ScrollingIncrement[scroll increment],0,1,1))),"")
This is the formula listed in the dynamic chart data, but it is returning the wrong value. It should be 52, but it is returning 2.
Also, I want it to be able to show 40 different timelines, but everytime I try to go past line 12, it won't show any further data.
This is the template I'm using: https://create.microsoft.com/en-us/template/date-tracker-gantt-chart-ff21fe25-50af-4c89-baa8-2e6e07f37e94
4 Replies
The formula in D15 on the hidden sheet calculates the duration of the first activity.
The start date of this activity is =TODAY()-1 and the end date is =[@[Start Date]]+1, so as I write it is from 28-Aug-2023 to 29-Aug-2023, i.e. 2 days. How do you arrive at 52 days?
HansVogelaar this is the data it is pulling from. The 2nd row is where the error is happening from the hidden data sheet.
For what it's worth, here is a version where I disabled the non-working scrolling part.
