Help with COUNTIFS formula
Hello all,
I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing around with a V-LookUp formula but received feedback that the below formula may be a better option:
=COUNTIFS([Staff Info ID]1:[Staff Info ID]3147=[RNs List ID]1:[RNs List ID]3332)>0, "output if true", "output if false"
I keep receiving error messages when inputting the above formula. Any help would be greatly appreciated!
Answers
-
assuming that [staff info ID] is the new ID numbers you are using and you want to see if those numbers appear in the old [RNs List ID] list.
=Countif([RNs List ID]:[RNs List ID],[Staff Info ID]@row)
Anything above 0 appears in both list. If you want it to return a statement just add =IF with it
=IF(Countif([RNs List ID]:[RNs List ID],[Staff Info ID]@row) >0,Yes,NO)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!