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
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!