If/countif returns incorrect arguement


So I'm using the following formula and getting errors.


Basically, I'm trying to get a return of CURRENT if any of the values in the "ID DUMP" column are in the "ID" column, and then a NEEDS if the number in the "ID DUMP" is missing.

I used the following formula in excel and it worked successfully.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!