I need help with COUNTIF formula when referencing another sheet
I have a 'main' grid that contains my detail (945 rows) where each row has an employee ID, QuarterEnd, and Quarter fields. The QuarterEnd is populated with 12/31/2022 or 03/31/2023 and I'm using a nested IF statement to arrive at the Quarter to display as Q4-2022 or Q1-2023.
I'm calculating metrics in a separate sheet where I need quarter and monthly counts. For quarterly counts, I'm using =COUNTIF({EmployeeID}, {Quarter} = [Primary Column]@row), but am receiving 0 count. What am I doing wrong?
Answers
-
-
Thanks so much, but I finally got the formula to work by using:
=COUNTIF({Quarter}, [Primary Column]@row)
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!