Can you conditionally fill columns of certain rows?

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!

Hello @Charlie_LA ,

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

Kind regards,


1 Like

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.


Thank you, worked perfectly!


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.