Revenue Formulas
Hello
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
Comments
-
Hello,
I'm not exactly sure how your sheet is set up other than that bit in the screenshot, but you can do this in a few ways.
If you have a bookings/daily log sheet with totals, you can use a SUMIF or SUMIFS function to sum only the values that fall within a certain date range (using the DATE function as well).
More on these functions:
Here's our complete functions list: https://help.smartsheet.com/functions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives