Answer: Using Spreadsheet Pricing method you can have a condition and based on the condition the other pricing parameter appears or else gets suppressed.
When creating the Spreadsheet Price Engine in your Pressero account under Preferences > Price Engines, you need to add the cell mapping for output cells, the cells with the quantity parameters, and any other parameters that match to the spreadsheet file that is going to be used by that price engine. A screenshot of how that will look, and the values used to map the cells on the example spreadsheet are shown below.
In the attached Spreadsheet you will see there are three Pricing option i.e
ii) What type of paper do you need ?
iii) The Color Option which will only appear if the value of the above condition is "Colored Paper"
Now you can notice that in the cell D3 there is an if else condition statement as indicated below:
And based on the above if "What type of paper do you need"="Colored Paper" then only return true or else false.
In D4 cell you will see there is another formula as stated below :
This means if the above D3 condition is True then only shows the B5(Color option) or else do not show the option.
Hence using If else you can set a condition as stated above so that the following option only shows if the first condition is true or else suppress the option.
Note: This is a test sheet hence you can refer this and design your own spreadsheet for your products.
Related article :