Return the row number(s) that a CountIf, SumIf returns as TRUE.
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?
Answers

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
Help Article Resources
Categories
Check out the Formula Handbook template!