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.
![Screenshot 2024-01-18 101633.png Screenshot 2024-01-18 101633.png](/t5/image/serverpage/image-id/31852i1D74439B9EF1B6CE/image-size/large?v=v2&px=999)
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?