Hiding dropdown values on a form
Hi Smartsheet users!
I have a sheet for selling fruit to two different customers, which includes a column called, "fruit type" of the dropdown variety. The values it contains are, "apple, banana, pineapple, orange, lemon, mango".
Both customers interact with a custom form made for them. Both forms have the "fruit type" dropdown, but I want customer A to only see apples and bananas, while customer B sees the other options.
It's not practical to build two separate columns in my sheet for this (because in reality I'm dealing with nine forms).
Is there a way I can hide the values of a dropdown for a single form? Other solutions to this?