Hello! This is our situation
We have a couple of boards that have IF statements based on 4 SKUs. On each board we input how many bottles of each SKU were ordered (sometimes manually, sometimes pulled w/integration), and so we get a subtotal column for each SKU + tax + shipping + etc.
However, prices changed last week and so I need a formula that will allow me to use X price before Oct 10 2022 and Y price after.
These are a couple of examples of the formulas already in place:
- This example is a column for one single SKU, but depending on the label it will mark different prices (for example employees have a secial price, if its a sample its 0). The one changing is the 331.03 priced one:
multiply({Limón},150),(IF({Canal#Labels} = “Empleado - Gratis”, multiply({Limón},0),(IF({Canal#Labels} = “Muestra Venta”, multiply({Limón},0),(IF({Canal#Labels} = “Muestra Mkt”, multiply({Limón},0),multiply({Limón},331.034483)))))))),2)
- But then I have this other type of formula when on 1 board we have multiple retailers, so the price for 1 SKU depends on the retailer (retailers edited for privacy):
IF({Retailer#Labels} = “1”, multiply({Junior},336.36),IF({Retailer#Labels} = “2”, multiply({Junior},325),(IF({Retailer#Labels} = “3”,multiply({Junior},334.55),(IF({Retailer#Labels} = “4”,multiply({Junior},311.32),(IF({Retailer#Labels} = “5”,multiply({Junior},325.26),(IF({Retailer#Labels} = “6”,multiply({Junior},376.04),(IF({Retailer#Labels} = “7”,multiply({Junior},325.25),(IF({Retailer#Labels} = “8”,multiply({Junior},292.73)))))))))))))))
There are already so many IFs and labels I have no idea how to add this other level to the formula. My knowledge on this is limited and now its become time sensitive, hopefully someone has the solution to help us.
Thank you!!!