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

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!