Need help with CountIF formula capturing monthly tags
Hi all, I am simply trying to reference each time the business line is mentioned per month. I think I am close? Month number = helper column calculating month. Legacy PCS = the business line I want to count per month. THANK YOU!
=COUNTIFS({Month number}, "1", [{Business line}, "Legacy PCS"])
Answers
-
Hi Nikole,
Give this a shot and let me know if it works for you:
=COUNTIFS({Month number}, 1, {Business line}, "Legacy PCS")
-
Hi there - I am getting an argument error?
-
The { } brackets from your initial post indicates these columns are being referenced in a separate sheet.
You may have to research the secondary sheet that contains these columns.
Add a test column to the secondary sheet and see if this formula works from there:
=COUNTIFS([Month Number]:[Month Number], 1, [Business Line]:[Business Line], "Legacy PCS")
I was able to replicate the scenario without issues.
See if you can verify these columns in { } brackets are in alignment by clicking
"Reference Another Sheet" from the initial sheet.
-
hi there sorry it was seemed to not work and then a half dozen tries later we are in business thanks!
-
I'm glad this ended up working for you :-)
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!