In order to write a value to the currently signed in user’s row from a different sheet, you need to:
-
create a template column
-
point it to User Profile >Row ID or Email
-
create a relation column that links the two sheets by this value
Only then can you do a “set column” action to the user profile sheet.
A better solution would be to enable the “User Profile >” reference natively within the Set Column action (just like how we can access it from filters, ITE columns, Template columns, and
Math Columns)