I’ve searched the forums rigorously but can’t seem to find a solution.
My problem is pretty simple,
I have one table called “Shipments”. In that table there’s a field called “Supplier” where we fill in the supplier when registering new deliveries.
Secondly i have another table called “Top Suppliers” which basically only contains one field called “Top Suppliers”.
What i want to achieve is that when the field “Supplier” is filled in with a supplier that is in the list “Top Suppliers” from the second table it highlights it with a colour.
Feels like the solution could be simple with a formula field but i can’t seem to wrap my head around it. Any suggestions? Grateful for any response.
If not this would be a great function to add to Airtable in the conditional colouring.
I.e"If Value A in Table A Is Not Empty Colour Value B"