Copying Text to Main Item Column

Here is what I am hoping to achieve. I have a board that I am setting up to be used as a calendar. I have everything set up the way I want except for one thing and I am stuck. One of my columns is used for Text. I would like to automatically copy the text from that column and copy it to the main column. This is only one possible solution:

For example:

I have in my table:

Event Cell 1 Cell 2 Cell 3 Event Time Cell 5 Cell 6

What I am trying to achieve is the result of:

Event + Time Cell 1 Cell 2 Cell 3 Event Time Cell 5 Cell 6

Because this will be in calendar view, the main item column (Name of the event) has to be the event. Otherwise, this first column shows in calendar view.

The other option is to somehow show the two columns together in the calendar.

I want my final outcome to be the calendar view that shows Event Name Event Time in calendar and I can’t seem to make that happen.

2 Likes

not very clear with what do you mean by main column?

My apologies. The very first column you see to the left that has each item’s name, such as person, item, custom, etc. The name of each row.

1 Like

Which product (CRM/Work Management, etc) and level (Pro/Enterprise) do you have?

Hi Desiree, This is Work Management Pro Plan. On a side note, I was experimenting with the new MondayMagic.ai system and I created a board for something completely unrelated. Somehow, this was actually able to do what I was looking to do…only thing is I do not know how it was able to do that lol.

1 Like

I can’t think of a way to do this with Pro. With Enterprise, you’d have access to the Workflow Center which gives more options. Did you figure out a way to do it with magic?

Desiree - www.thecleverclovers.com

Hi, maybe you can workaround this creating a formula column that sits right after the Item (main) column?

Use the formula:

CONCATENATE({Name}," ",{Time})


this will be the result (you can use format_date() arround concatenate to format it anyway you like)

I also can’t find a way to autochange the name of the Item… That’a a shame, but maybe this helps?

Keep in touch,

@Taylor1430

You might consider using our Column Magic app with a custom automation similar to this:


Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

Hi @Taylor1430,

If your end goal is to show the event time in the calendar, and you’re open to using apps, you could consider Calendar Plus. It will show your event’s time (free plan) and you can also show item column values (like statuses, assignees, dates, etc.) on your calendar items.

Alternatively you can use one of the Automato automations:
When column changes Then set item name to value(1)

The value can substitute item values.

Best of luck with solving this!

–
Install Calendar Plus