List Relation "Data"

BAM! I figured it out.

First create an If/Then column on the user profile sheet that fills the column with the word ‘Name’ if signed in user.

Next, on every sheet you want to display the name:

  • Create a template column that contains the word ‘Name’.
  • Create a relation column that joins the name template to the name template in the user profile sheet.
  • Create a lookup column that gets the name from the relation.
  • Bonus - make it look pretty.