Incorrect Argument - Second set of eyes please

I'm not sure what I'm missing but would appreciate some help with the below formula it is giving me an incorrect argument set and I can't figure out why.

=COUNTIFS({Greet}, OR(@cell = "yes", @cell = "NA"), {Week Beginning}, [Report Date]@row, {Monitor Type}, "Monitor") / COUNTIFS({Greet}, OR(@cell = "yes", @cell = "no", @cell = "NA"), {Week Beginning}, [Report Date]@row, {Monitor Type}, "Monitor")

Best Answer

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

    Syntax is right, so the other thing that can cause that error is range sizes not matching. Double check your cross sheet references to ensure they are all the same size and shape.

    I have trouble sometimes with this when I am referencing a large sheet or my internet is behaving poorly. Sometimes it takes a few extra seconds for the sheet to fully load in when you are selecting the range for the cross sheet reference. When the sheet does fully load in, the selection will always revert to the "home cell" or the cell in the top right corner. Even if you have already clicked on a column header. Then I have to go back and edit the reference and pause for a few seconds to let the sheet load into the window. You should be good to go when the sheet name appears near the top left of the window.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!