Hi, I'm sure this question has already been asked but still can't find an easy answer. It seems as though it should be quite simple but I can't wrap my head around it.

As per the screenshot, I would like to automatically combine Linked Record entries from multiple fields into 1 field. The 1 combined field needs to keep this data as Linked Records, and not as formula text.

The  Linked Records are from another Table in the same base.

So basically, if this automation or formula was setup properly - the "ALL COMPLETED PROJECTS" field would contain 3 Linked Records: "Pen", "Pal" and "Pol".

Is this possible?