We have a board used for comparing prices of products that we can get from multiple suppliers. We wanted to have the lowest value of a row highlighted. I could only find a way to highlight values based on a specific value.
I asked our programmer to help us out and came up with the following formula:
SWITCH(
MIN(
{Supplier1},
{Supplier2},
{Supplier3},
{Supplier4},
{Supplier5}
),
{Supplier1}, "Supplier1",
{Supplier2}, "Supplier2",
{Supplier3}, "Supplier3",
{Supplier4}, "Supplier4",
{Supplier5}, "Supplier5",
"-"
)
This shows a column with the name of the supplier that has the cheapest price. It’s not completely what we wanted, but I’m happy with the results and I hope someone else will find this useful!