How to calculate weekly GP on a gant chart?

Jef Forward
Jef Forward ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All - I dont believe this is possible with smartsheet - but I want to make sure before I purchase a one off.

I have included a screen shot below to illustrate my goal.  This screenshot is from a colleague who uses FastTrack for this one and only purpose.

I currently have a master schedule that shows all of our construction projects.  At the bottom, or top, I would like to see the cumulative gross profit per week, per month and per quarter.  

I really dont want to buy FastTrack - If I cant get this done on a gant chart, any suggestions otherwise?  I appreciate any suggestions...Thanks Jef

GP drop per week.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!