Trying to count a flagged item
![Samuel Dowdy Jr.](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
=COUNTIFS({MASTER - Daily Report - Employee}, [Employee Name]@row, {MASTER - Daily Report - Date}, @cell >= [Start Date]@row, {MASTER - Daily Report - Date}, @cell <= [End Date]@row, {MASTER - Daily Report - Late}, 1)
Can you help with this formula? Im getting #Incorrect Argument
Answers
-
- For functions that take two ranges: The range sizes don’t match for the function.
- The function is missing an argument.
- There is an extra function in the argument.
The structure of your formula above is correct, so the error is not coming from the way it's written (points 2 & 3 above). My guess is that the error is coming from the {ranges} you selected.
Is it possible that one of the cross sheet references is only looking at a selection of cells instead of an entire column? I would use the Sheet Reference Manager (right click on any cell to choose this from the dropdown) to confirm the size of each of your ranges and make sure they match.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!