Getting Inconsistent and unreliable total float values that do not make sense.

Good evening,

Whilst working on a specific project, we experienced several dissimilarirteis in Total Float in Gannt View and Grid view.

I have highlighted Row#10, Row#17, and Row#19.

If you look at Row#10 under Gant view we have 11 days of total float. however, in the grid view it shows 0.

In Row 17, it shows 2 days of float in the grid view but in gantt view, we can see that we have 16 days of total float.

In Row 19, grid view shows 2 days of float but in reality we only have 1 as you can see in the gantt chart.

We are also getting -1 float for Row 29 and Row 31.

The formula we have been using is - TOTALFLOAT([Task Name]@row)

Any leads are appreciated. Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!