How to use _ThisRow

[Orion_Szathmary]

Can anyone recommend a spot where I can learn more about how to use _THISROW? I see it used often but I can’t seem to find a great explanation of how it works i.e., how does the computer determine which row is this row?

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Back-references within nested queries ([_THISROW-n]) Consider a complex App formula with “nested” SELECT() expressions (SELECT() expressions within SELECT() expressions): SELECT( table[column1], ... SELECT( table[column2], ... SELECT( table[column3], ... ) ... ) ... ) Let’s call the row for which this entire expression is evaluated as its App formula the Origin Row. Within this entire expression, we can refer to column values of the Origin Row by dere…

[LeventK]

Chiming in our expression Magician @Steve

[LeventK]

Seems the magician had already arrived before my chime

[MultiTech]

This was one of the questions that my Patreon supporters asked me to do a video on:

I’m not too satisfied with this video, I’m gonna try again at some point, but hopefully I made SOME sense in here.