Using SUMIFs on Calculated columns does not "add" up?
I'm stuck - I am trying to use a SUMIFS on a calculated column, but it doesn't appear possible.
Example of my Smartsheet columns
I am determining the value in the "YEAR" column using a column formula:
IF([Date@row < DATE(2023, 1, 1), "2022", "2023").
MY ISSUE:
I would like to do a SUMIFS based on the vendor AND the YEAR. I want to sum up the amounts by year and by vendor
My formula:
=SUMIFS(Amount:Amount, [Vendor]:[Vendor], "Alpha", [Year]:[Year], 2022)
I was expecting to see $150.50. However, I am getting $0.00.
Now, If I enter in the year directly (type in 2022 into the year column), I get the correct answer of $150.50 and everything works.
So....what can I do to make this work?
Answers
-
Try this
=SUMIFS(Amount:Amount, vendor:vendor, "Alpha", Year:Year, ="2022")
Your year formula turns 2022 from a number to a Text with "". So by using the ="2022" makes it look for the text.
-
Got it. Wasn't thinking the variables should all be text.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!