Not actually sure if they are called cells in Coda so I have kept the name from Excel.
Basically, I have a cell that has the content: ‘Flat’ and another table with a multi-select column with the contents: ‘Flat’, ‘Slight-Curve’ and ‘Rounded’
I am trying to create an ‘IF STATEMENT’ where if multi-select matches the word i.e. ‘Flat’ then display the associated cost.
I have managed to do this if both cells have the content: ‘Flat’ but if the multi-select cell has more than one selection it won’t work.
How can I search through the multi-select cell and target an individual selection as I am guessing at the moment, it seeing ‘Flat’ in one cell and ‘Flat’ ‘Slight-Curve’ ‘Rounded’ in the other which is not a match but by taking out the other two selections so the multi-select is just ‘Flat’ it’s obviously a match?
Here’s my current code:
If([Digital Media].[Application Surface].Contains(thisRow.Description),[Digital Media].Filter([Application Surface]=thisRow.Description).[Sales Price (per metre)],"Error")