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,@Scroll...
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.