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!


  • jpaul
    jpaul ✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!