How to calculate weekly GP on a gant chart?

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

Find more posts tagged with

Construction

Formulas

Gantt View

Comments

Andrée Starå

Hi Jef,

A dashboard with the report first and then the cumulative gross profit below/above.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jef Forward

Hi Andree - yes that could work if the columns lined up. How would that work?

Jef Forward

After some research, I think the only thing I can do is to fake a gant chart look in a simple spreadsheet. This will allow me to have a gp formula in my week number columns. I can very easily link in all of my projects info and critical dates, therefore being automatically updated when the project are updated by my project managers.....hhmmm

Andrée Starå

I'm not sure it will, but it could be something to try out, and it's probably a little trial and error before it will.

My thought was either to have a report on top of the dashboard or the web content widget to show the report in that way (depending on what would line up the best.

It might also work with the metric widget.

Hope that helps!

Best,

Andrée

Andrée Starå

That sound like a great workaround.

I'd be interested to see the finished sheet/solution if possible.

Could you share it/a copy with me (andree@getdone.se) or maybe upload a screenshot?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…