Trying to have the phone number of a person appear next to the phone. Added a phone number column and it works no problem.
But I’m trying to have the number associate with every entry of that name. If a new form is submitted the new row does not contain the phone number.
Tried to use a relation/lookup to attach the number to that person, which works, but there is no option to add this column in the phone screen. Relation columns made in Glide tables do not appear in the spreadsheet?
Also attempted Index Match in the spreadsheet. This worked as a standalone formula but I can’t seem to make it work as an array (so that it applies all the way down the column).
Anyone know where I’ve gone wrong?