Project Management Plan - Schedule Health Formula

Options

Hello,

I looking to apply a formula to my Project Management plan whereby a color is assigned to each row given the "% Complete" and the "Start Date" "Finish Date". I want the health of the children rows to roll up into the Health of the parent row.

I've used one of the templates with a built-in formula, however it does not work / accurately reflect status (ie status is still red when a task is complete).

Reference Cells: Start Date, End Date, % Complete

Blue = Task Start Date is greater than Today and % Complete is equal to 0

Green = Task Start Date is greater than Today and % Complete is greater than 0

Green = Task End Date is greater than Today and % Complete is greater than 0

Green = % Complete is equal to 1

Yellow = Task Start Date is less than Today and % Complete is less than 1 but greater than 0

Red = Task Start Date is less than Today and % Complete is equal to 0

Red = Task End Date is less than Today and % Complete is less than 1

As mentioned, if someone could assist with this, I would be very appreciative!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!