Referencing Sheet using three attributes / one being NOT EQUAL TO
Hello - am am running a VLOOKUP to 1 sheet, and currently pulling 2 attributes, which works. (see below)
=COUNTIFS({Function}, "Category Management", {Period}, "S-Cl", {Status}"
I want to pull the Function name (above), a Period (above) and avoid pulling any Status that equals, Complete. I can't seem to locate the right formula to accomplish - Hoping a Guru can help!
My failed attempt.......
=COUNTIFS({Function}, "Category Management", {Period}, "S-Cl", {Status}, "<>Complete")
Answers
-
The formula looks right except for the not equal part. Needs to come before what its searching for.
=COUNTIFS({Function}, "Category Management", {Period}, "S-Cl", {Status}, <>"Complete")
-
@Nic Larsen - Thanks for the quick reply to my formula question. I adjusted my formula but unfortunately it comes back with an error - "Incorrect Argument Set".
Any other ideas?
=COUNTIFS({Function}, "Category Management", {Period}, "S-Cl", {Status}, <>"Complete")
-
Hmm interesting. I created the same setup using cross sheet references for the columns and it works using the formula below. The only part I am not using is a vlookup and maybe that's the issue, but not 100% sure. How is that being used? Are there 3 sheets in play?
=COUNTIFS({Function}, "Category Management", {Period}, "S-CI", {Status}, <>"Complete")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!