Total Float Formula

I would like to use this formula to know how many days I can push out a task without impacting our ship date.

I tried this formula but it tells me 0 days for every column and that can't be right. How can I indicate the project finish date is the ship date?


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Katie Aldrich

    The TotalFloat will find the last date listed in your End Date column, or the column you have selected in your Project Settings as the End Date, and will see how many days tasks can shift and update yet still hit that target end date.

    This means that if you're using the End Date column and have all of your tasks leading up to the final row linked to each other via dependencies, then there is no wiggle room and your TotalFloat will find 0 days that you can shift.

    However if you have a different target end date than what you have listed in the actual tasks, you just need to 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 in the entire project and re-calculate based on that!

    This means that in the screen capture above, if your Second Row is the one that lists the target date, fill in the "Task Due Date" cell with the same date (you could make it a milestone with 0 duration) then it should update your formula.

    Let me know if this makes sense and works for you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!