Calculates the number of days that a task can be delayed without impacting the project finish date.
Sample Usage
=TOTALFLOAT([Primary Column]@row)
  • Value
  • Value
    The row at which you would calculate the TotalFloat function

=TOTALFLOAT([Task Name]@row) 

This formula function returns the TotalFloat for this given task at any specified row.

If you haven't enabled dependencies, you may see the #INVALID COLUMN VALUE error.

You can reference any column as the Value, as long as the row reference is the correct row to evaluate.   

Still need help?

Use the Formula Handbook template to find more support, resources, view 100+ formulas, a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community