I have a board “Project Planning” which is connected to “System Planning” board. The item name in the “System Planning” board consists of a concatenation of the Item name in the Project Planning board with a suffix, e.g. “-xxx”.
I would like to automate population of the Connect board column linking these two by pasting the value of “Concatenate({Planning Board},”-xxx”) preferably without creating a formula field.
At the moment this isn’t possible natively without a formula or external tool. monday.com automations can’t dynamically link items by matching a concatenated value or searching by item name.
Common workarounds are to create the linked item at the same time with the suffix applied, use a temporary Formula column to generate the value, or handle the lookup and connection with a tool like Make or Zapier.
If you’re still running into issues or want to talk through the setup you’re working on, feel free to book a quick session with our team and we can walk through it together.