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.
“blue, green, red” should be filled in all rows with the name “polo”.
Is there a formula for this?
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
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!