Total Float - No Longer Working - Returns Invalid Value


I added "Total Float" to my schedule in late March.

The calculation appeared to be working correctly at the time.

Over the past few weeks, I noticed more and more activities would return "#invalid value".

Now everything in the Total Float column as "#invalid value".

Is there something that I need to do to refresh this column?

I have tried to delete and replace the column. Note that "Dependencies" are turned on.

Best Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @sdb60411

    I agree that it would be helpful to see your sheet (without sensitive data). I know that TotalFloat does not always work if there are more than 1 predecessors listed in the row, so if you have multiple values in that column this could be the cause.


  • sdb60411
    Answer ✓

    Yes. I have multiple predecessors against many of the tasks. If it doesn't work with multiple predecessors, then that may very well be my issue.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!