If/countif returns incorrect arguement

Options

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

=IF(COUNTIF([ID Dump]:[ID]), "CURRENT", "NEEDS")

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.

=IF(COUNTIF(X:X,A:A),"CURRENT","NEEDS")

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!