Forum Discussion

Kupka8's avatar
Kupka8
Copper Contributor
Aug 29, 2023

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...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Aug 29, 2023

Kupka8 

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?

Kupka8's avatar
Kupka8
Copper Contributor
Aug 29, 2023

HansVogelaar this is the data it is pulling from.  The 2nd row is where the error is happening from the hidden data sheet.

 

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 29, 2023

    Kupka8 

    I see. It has something to do with the scrolling offset in B8 and the charting range in B11:B12, but I cannot discover the logic behind it. The person who designed the template appears to have intended the chart to display a date range of 16 days, but flunked it. I wouldn't rely on this template.

Resources