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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!