formula to reflect the phase % complete
Options
System
Employee
This discussion was created from comments split from: Percentage (%) complete formula.
Answers

=IF([End Date]@row, TODAY(>), 1, [0])
I was working with Smartsheet Pro and I did not get the formula down corectly.
Need the formula to reflect the phase % complete. If there are five tasks and only one is done I want to set/calulated based upon the phase as a percentage.

Do you want it to average the % complete for each of the children tasks?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!