I have two tables:
- List of parties
- People who can be invited to the party
In the list of parties, there is a lookup column for people who can be invited to the party.
I am copying over the values from a sheet, and everything works fine in the list of parties, the people are correctly added as lookup values and I can open their rows by hovering over their name.
HOWEVER, when I add a column to the second table with “List of parties to which that person has been invited”, the formula doesn’t work and displays nothing.
Whenever I then go ahead and remove the copied values + select them from the lookup list, the formula works…
Anyway to fix this bug?