Skip to main content

Hi,



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"

You can’t highlight a cell with a color in Airtable, if that’s what your trying to do. You can tag a record with a color if you are using a Pro account. But you can also just use a formula field that outputs eye-catching emoji when a “Top Supplier” is found.



The way you’d identify a Top Supplier would be much easier if you just defined the Top Sellers in a formula field in the main table, than having them in a separate table. The. You could just use the FIND() function inside a conditional like so:



IF(


   FIND(


      {Supplier},


      {Top Suppliers List}


   ),


   “✅ Top Supplier”


)

Reply


Terms & Conditions