I see that lookup fields now have an option to limit the data shown, but it seems very limited to only showing you the data associated with first or last record linked?
Is there any way to limit to unique selections only but retain the color labels? We use color on single select to indicate different things like status and priority. So while i can use a Rollup Array Unique, that loses all color and becomes a comma separated list. And no, i do not want to make a special automation to then copy said results to a new field showing the results, as this is excessive and not 100% reliable when there is automation errors or server errors, etc.
Would love if Rollup field could retain color on the unique array, OR lookup fields to offer more flexibility to show the unique selections.