Revenue Formulas

edited 12/09/19 in Smartsheet Basics



I need to take our revenue and break it down into revenue per month, and revenue per quarter and return each value into a separate cell. 

So take extended sell based on month (I have another column on my sheet called Date Shipped) and add it all up into a cell. Same for the quarterly.

I would be open to having the revenue calculated via a formula to a cell for each month then a formula to calculate it per quarter. That way I can see the per month total for future reference. 

I'm not looking to do this via a report as I want it to populate other tings once the data is generated. 


Thanks in advance