COUNTIF leads added last week


Good day!

I'm working on this new KPI report for leads added last week, and I'm using this formula:

=(COUNTIF({Aldo Aguilar - Pipeline Range 1}, "2 - Upselling", "4 - Lead Generation", COUNTIF({Aldo Aguilar - Pipeline Range 2}, WEEKNUMBER(TODAY(-1)))))

But at the moment that I hit enter, it returns "#INCORRECT ARGUMENT". Is there something I'm missing on my formula?

Thank you very much in advance for your help.


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    My apologies. I saw the syntax issue and missed what we were actually trying to accomplish.

    Try moving the -1 portion to outside of the WEEKNUMBER portion. By having WEEKNUMBER(TODAY(-1)) you are basically pulling the week number for yesterday. WEEKNUMBER(TODAY()) - 1 will pull the week number for today and then subtract 1 from that.

    =COUNTIFS({Aldo Aguilar - Pipeline Range 1}, OR(@cell = "2 - Upselling", @cell = "4 - Lead Generation"), {Aldo Aguilar - Pipeline Range 2}, WEEKNUMBER(TODAY()) - 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!