Why is the formula saying invalid operation?

Alex191

I have a Smartsheet page that I am trying to pull data from between 2 dates. The formula below is the one I am using but it says invalid operation?

=SUMIFS({Work In Progress - 2021 - Range 3}, =[Primary Column]@row, {Work In Progress - 2021 - Job Value Range 3}, {Work In Progress - Job Value Range 1}, <=DATE(2024, 3, 31), {Work In Progress - Job Value Range 1}, >=DATE(2023, 4, 1))

please advise what is going wrong?

Paul McGuinness

Hi @Alex191

looks like you may have your first criterion range and criterion reversed?

see if this fixes it?

=SUMIFS({Work In Progress - 2021 - Range 3}, {Work In Progress - 2021 - Job Value Range 3},=[Primary Column]@row, {Work In Progress - Job Value Range 1}, <=DATE(2024, 3, 31), {Work In Progress - Job Value Range 1}, >=DATE(2023, 4, 1))

Hope that helps

Thanks

Paul

Alex191

Hi @Paul McGuinness,

What I am trying to do is get a figure between 2 dates that matches the primary column to pull a total value I will put some attachments below so hopefully you can see what I am trying to achieve.

Ignore where there is a total under 2021 as that is wrong and not live data.