Syntax
TOTALFLOAT(Value)
- Value—The row where you would calculate the TotalFloat function
Sample usage
=TOTALFLOAT([Primary Column]@row)
Usage notes
- Calculates the difference between the task’s latest start or finish date and its earlier start or finish date using dependencies.
- This function works with single predecessors.
- Tasks on the Critical Path will show 0, as their dates are critical, meaning any delay will impact the project’s end date.
- If you haven't enabled dependencies, you may see the #INVALID COLUMN VALUE error.
Examples
=TOTALFLOAT([Task Name]@row)
Replace "[Task Name]@row" with the appropriate column reference in your sheet, ensuring the row corresponds to the task you're evaluating. You can select any column as the reference.
This formula function returns the total float for this task at the specified row.
Keep in mind
This function finds the last date listed in your End Date column, or the column you selected in your Project Settings as the End Date, and sees how many days a task can shift and update while still hitting the target end date.
If you use the End Date column and have all of your tasks lead up to the final row linked to each other via dependencies, then there is no wiggle room, and your TotalFloat will find 0 days to shift.
However, if your target end date differs from what you have listed in the tasks, you must ensure that the row where you state your target date is set up as a task row with a Start Date and End Date. Then, TOTALFLOAT will be able to recognize it as the final date for the entire project and re-calculate it based on that.
If you have an Enterprise plan, you can use AI to help write and troubleshoot formulas.
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.