Formula on a Gant Chart

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!