Calculates the number of days that you can delay a task without impacting the project finish date.
Syntax
TOTALFLOAT(Value)
- Value—The row where you would calculate the TotalFloat function
Sample usage
=TOTALFLOAT([Primary Column]@row)
Examples
=TOTALFLOAT([Task Name]@row)
This formula function returns the TotalFloat for this given task at any specified row.
You may see the #INVALID COLUMN VALUE error if you haven't enabled dependencies.
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.