Return the row number(s) that a CountIf, SumIf returns as TRUE.

Nlarkin

Hi team!

I have a relatively complex countifs(yadda yadda yadda) formula telling me if something is wrong with any of the hundreds of rows in a sheet.

Now, I need a cell to identify the SmartSheet row numbers where the countifs() is true so the sheet admin can navigate right to the rows that have problems and correct it. I can't figure out how.

I want it to be:

<cell1>Is Something Wrong Somewhere?</cell1><cell2>TRUE</cell2><cell3>5,12,750</cell3> where cells 5, 12 and 750 are the rows where the countifs() resolved to TRUE.

I tried complex nested INDEX(COLLECT(@ROW())) statement which did not work. Any ideas?

Krystle McMaster

I haven't seen anything return a row number before, especially since the row numbers are apt to change. Do you have a helper column that just counts up as a Unique Row ID? That may work