IF(COUNTIF Returning #invalid ref

Nancy Heater
Nancy Heater ✭✭✭✭
edited 03/23/23 in Formulas and Functions

Hello smartsheet community!

We are using the following formula to look up data across multiple sheets to see if the client ID exists elsewhere. I can add in the first (6) sheers to reference and it works just fine. When I start to add the remaining (3) sheets, it breaks.

I also tired to remove one of the current references to a known 'working' sheet, and add in one of the remaining (3) sheets and it also breaks.

All of the sheets columns we are referencing are formatted correctly, and this same formula is working correctly in other sheets. I am stumped.

IF(COUNTIF({sheet 2023}, =ID@row) + COUNTIF({sheet 2022}, =ID@row) + COUNTIF({sheet2021}, =ID@row) + COUNTIF({sheet 2020}, =ID@row) + COUNTIF({sheet 2019}, =ID@row)> 0, 1, 0)

Thanks in advance for the assist!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!