Formula help to view a specific month
Hello,
I currently have the formula below. Curious if anybody could help me change the formula to be a specific month like July, June, September. Any help is appreciated
=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, =MONTH($[Column9]$26))
Best Answers
-
I'm not sure I follow. Are you wanting to change the {Current month} to a specific month, or are you trying to search that range for a specific month?
-
Thanks for the help. Says unparseable, but I think I figured out a different way around it. Appreciate your time and answers.
Answers
-
I'm not sure I follow. Are you wanting to change the {Current month} to a specific month, or are you trying to search that range for a specific month?
-
Thanks Paul! to a specific month.
-
You are trying to change the data in the {Current Month} range to s specific month?
-
Yes. Sorry the formula right now is set to always look at the current months data. But i want to be able to have a new formula set so i can see a specific month. So instead of viewing August (current month) i would like to see July and June. Hope that is more clear. In any case thanks.
-
Oh. In that case you want to adjust your criteria and not the data within the range. To do that, you would change the criteria to the month number you want to search for.
=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, =MONTH($[Column9]$26))
For June:
=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, = 6)
For July:
=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, = 7)
-
Thanks for the help. Says unparseable, but I think I figured out a different way around it. Appreciate your time and answers.
-
Are you able to copy/paste the exact formula that is causing the error directly from the sheet to here? The formula I provided shouldn't be throwing that error.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!