Formula
Hi,
Hopefully I'll explain my predicament correctly!
Ive set up a sheet for the commercial department to track orders. I need a formula to track the value of orders quoted in a certain month.
The column I need the date range to come from is called Date Out
The column I need the descriptor to come from is called Status, and the descriptor in this instance is named - Quote Sent Out
The column to calculate from is called GRP.
Hope someone can help?!?
Thanks
Comments
-
The only way I have been able to get it to work is to add a support column which you can shrink the width to the minimum, use white fill, and use white text to hide it a little bit. You can also put it anywhere within the sheet. I usually stack my support columns on the for right, do all of the above, and lock them.
In your Support Column enter:
=MONTH([Date Out]@row)
In your totals column enter the following:
=SUMIFS(Value:Value, Status:Status, "Quote Sent Out", Support:Support, #)
(Replace the "#" with whatever month number you are calculating for)
I have tried about a million different ways to get it to just look at the month in COUNTIF and SUMIF functions to avoid adding a column, but I either get an error, "0", or "1".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Wow! Thank you for your help. Enjoy your weekend!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!