Gantt - Progress Ahead or Behind Schedule?

Chris_Bick
Chris_Bick ✭✭
edited 12/09/19 in Formulas and Functions

Hi All

I'm keen to look into options to report on project progress against schedule.

Generally we set a project programme, then progressively update %Complete against lines and the project progresses.

The progress bar works well as visually indicating if each activity is ahead or behind the current date.

I'm looking to try to measure this progress.Β  Β (ie, 10 days ahead......or 6 Days behind)

In the attached programme, the project is indicating its approx 6 to 7 mths ahead of programmme.Β  How can i get a column to automatically tell me how many working days ahead?

Thanks!

Annotation 2019-04-11 114244.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!