Full Name By Template In Profile

Since we are moving our data sheets now to the glide table we had the flexibility to have a column where we can combine the First Name and Last Name of a user and then look it up in the profile section in glide as a full name

But now if we created a template column to combine both in Glide unfortunately only the first name or last name is allowed to be shown as no custom columns will be available to select

Another thing we created a workaround as well in google sheet for an array formula to check if the user is active and then pass it to a certain column and this will allow us to give or revoke access to acertain user by their email, but we can’t do this as well in Glide because if we used if condition column it won’t be selectable

Here’s a hack: