Create a column that indicates # complete a task should be per the start and finish dates.

Options

I want to create a column that indicates # complete a task should be per the start and finish dates. This will allow the user to compare expected vs actual % complete.

I have a helper column already that does this for the Risk Flag formula, but it can actually go below or above 0-100% depending on when the start and finish dates fall in comparison to current day. O only need 0-100%.

Best Answers

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!