Formula on a Gant Chart

Jacodb

I have a production sheet for units to be manufactured with a Gant Chart and dependencies. I also have the total number of units to be manufactured as well as the value per unit on my sheet. I would like to expand my sheet to include the value of the units manufactured per day. Is it possible to add a formula onto a Gant Chart to calculate vertically on the chart to determine the value of units on a specific day or even every day?

See the example of the sheet.

Smart Sheet.pdf

Genevieve P.

Hi @Jacodb

There currently isn't a way to display vertical lines on a Gantt chart like this, but please let our Product team know about your feedback and suggestion by filling in this form, here!

What you could do is identify your Value Per Day by taking the Total Value and dividing by the Duration. Then you could have a helper column which combines this value with the name of the Project in order to display this as a label in your Gantt chart. (See: Customize the Gantt Chart Display and Behavior) Would this work for you?

Cheers,

Genevieve