Why is the formula saying invalid operation?

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?

Answers

  • Paul McGuinness
    Paul McGuinness Overachievers

    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
    Alex191 ✭✭
    edited 04/28/23

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!