Using SUMIFs on Calculated columns does not "add" up?

D.W.

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?

Dan W

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.

D.W.

Got it. Wasn't thinking the variables should all be text.