Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Order value based on price breaks
I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price break.
The really clunky method I have used so far is two main nested IF formulas and additional columns:-
The first main nested IF (30 levels deep, one per product) determines which product has been ordered and puts the first price break into an additional column. This is repeated four times, once for each price break.
The second main nested IF then checks the quantity ordered, determines the applicable price break from the four additional columns and simply multiplies the quantity by the price break.
Does anyone have any ideas for a neater method available in Smartsheet? In Excel the Lookup functions would be used.