Синтаксис
TOTALFLOAT(Value)
- Значение—The row where you would calculate the TotalFloat function
Пример использования
TOTALFLOAT([Основной столбец]@строка)
Примечания об использовании
- 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.
Примеры
=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.
Обратите внимание
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.
Остались вопросы?
Используйте шаблон Руководство по работе с формулами, чтобы просмотреть дополнительные ресурсы и изучить более 100 формул. Руководство содержит глоссарий, описывающий каждую функцию, обращение с которой вы сможете отработать на практике, и примеры как часто используемых, так и более сложных функций.
Изучить примеры того, как эту функцию применяют другие пользователи Smartsheet, или задать интересующий вопрос можно в Сообществе Smartsheet.