I converted a select column to a related row so that I could use related row reference in other columns, based on the chosen value from the related table. That works.
But, I want colors for each items. Other products pick up the coloring from the related items. Apparently, not Spreadsheet.com. Coda, for example does this.
Is there any way to achieve this?
I am doing this for a client who will need a paid account, but not if the things that are needed don’t work.
Hi @Lewis_Levin, We don’t yet allow coloring for related row items. However, if you create a Select column in the related worksheet representing color you can use a Related Row Lookup to have a column automatically display the color when a related row is selected. This would achieve the effect you are looking for.
Related Row Lookup value automatically gets populated based on the value selected in a Related Row cell so users would only need to pick a Related Row value (assuming each related row has an assigned color already)