Multi-part calculation

ZMinior

Hello. I have an "intake" sheet in which I now have a calculation sheet in order to start putting numbers on a dashboard.

What I'm trying to do: Set up a formula where Smartsheet will (for example) sum the Units sold only if the Year is 2026, month is 1 and City is New York. Smartsheet has been hitting me with a "0" when I use the following formula:
=SUMIFS(
{Units sold},
{Year}, 2026,
{Month}, 1
)

I have tried putting both the month and year in quotes, to no avail. I haven't even tried adding location in yet. I'm sure I'm just missing something simple, but ChatGPT is getting angry at me. Any help is appreciated.

Darren Mullen

@ZMinior I believe you are on the right track with troubleshooting using quotes around the numbers, meaning sometimes numbers are stored as text in Smartsheet.

Assuming your ranges are setup properly, I suggest trying the following:

=SUMIFS({Units sold},{Year}, value(@cell) = 2026,{Month}, value(@cell ) = 1)

That should force the year and month in the other sheet to be treated as numbers.