Referring to the parent of my parent

App update!

This brilliant trick (List Relation “Data”) allowed me to achieve the following:

  1. Only need to create “is signed in user” rel/lookup once in user sheet with keyword and then can relate to that keyword in each tab
  2. able to create custom “headers” on each tab.

800+ rows & 20+ relation/lookup columns now boiled down to just 10 columns and 0 (new) rows…zero spreadsheet formulas = instant calculations.