Hi, I am looking for a way to create the following automation:
When an item is canged to X
Create a sub item concatination of text+X .
I know the automation of sub item creation but cannot find a way to modify the text of the sub item using concatination.
Any idea?
Thank you,
Hello @Nilis Welcome to the Community!
Hi,
Currently, Monday.com does not have a built-in feature to automatically concatenate text with a column value directly within the automation.That I’m aware of, however, you can achieve something similar by combining automations with Monday.com’s formula column.
Here’s a workaround you could consider:
- Set up the automation to create a sub-item when the item changes to X (using the “When status changes to X, create a sub-item” automation).
- Then, use a Formula column to concatenate the text with the status value (e.g.,
CONCATENATE("Text", {Status})). - You can then manually or using another automation, transfer the value from the Formula column into the sub-item’s text field if needed.
Unfortunately, there isn’t an out-of-the-box solution for direct text concatenation into sub-item fields using just automations at this time. Others here may be able to give more guidance on setting this up in a different way. But perhaps a suggestion in the mean time.
Let me know if that helps or if you need further assistance!
Hi Clare,
Thank you so much for the detailed answer.
I am not sure I understand the solution -
Why should I use the status column?
I have no problem creating the sub-item automation (Step 1).
At step 2 - If I use a formula column, I can only use in the concatenate expresion, columns from the sub-item and not from the item (where I have the value I want to concatenate).
Do I miss something or I need another solution?
Thanks again,
Nili
Hi @Nilis do you have an image of what you are trying to achieve to help me try and consider a solution?
I thought of using a forumula cell to " CONCATENATE({Name}, {Status}) " or perhaps AI extract text could work?
