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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!