Total Float - No Longer Working - Returns Invalid Value

sdb60411

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.

Genevieve P.

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.

Cheers,
Genevieve

sdb60411

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.

Andrée Starå

https://community.smartsheet.com/discussion/120874/total-float-no-longer-working-returns-invalid-value

Hi,

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

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.

Cheers,
Genevieve

sdb60411

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.

kdmarti24

@Genevieve P. - I have a sheet with multiple predecessors on many of the rows. How can I caculate Total Float? Is this a product enhancement that has yet to be developed?

Genevieve P.

Hi @kdmarti24

Yes - here is the Product Idea you can vote on to submit your feedback to the Product Team:

https://community.smartsheet.com/discussion/121310/total-float-function-work-with-multiple-predecessors