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.
