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
-
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.
Answers
-
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.
-
@Paul Newcome Thank you so much! That fixed it!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!