Can you conditionally fill columns of certain rows?

[Charlie_LA]

Hi Coda community!

I’m trying to come up with a solution to the below:

I would like to fill the INFO columns with the values from the DATA columns in rows only when the value is the same in the NAME columns.

For example:
“blue, green, red” should be filled in all rows with the name “polo”.

Is there a formula for this?
Thank you!

[Thierryvm]

Hello @Charlie_LA ,

I’m not sure if I understood correctly, but I’m going to make a proposal based on filter and concatenate
But I am sure there are other ways to do this more easily :). I’m still having a little trouble mastering the formulas

Kind regards,

Thierry

[Daniel_Stieber]

Hey @Charlie_LA
I’m also not 100% sure if I understand, but here is a solution of what I think i want to achieve.

I made two examples, depending if you want to fill the data with a formula automatically or if you want to fill it once as editable text.

The basic formula for the info column is

=[test table].Filter(Name=thisRow.Name AND Data.IsNotBlank()).first().Data

This will search for the first row that has the same name and available data and returns the data.

[Charlie_LA]

Thank you, worked perfectly!