Restricting dropdown options on forms but permitting on backend for editors

carmistead

I have a form with a question that has three restricted dropdown values. I only want 2 of those values to show on the form but on the sheet it populates to, I want a third restricted option available for a user with access to the sheet to edit.

Kerry St. Thomas

Since the dropdown is restricted, I'm thinking your option is helper columns. So for the existing dropdown (that's surfaced on the form), include only the 2 values you want surfaced in your dropdown. Create a new dropdown column (I'll call this "Override") that's not surfaced on the form at all, but is available in the sheet itself, that has all 3 values. Finally, create a dropdown that basically flattens the two dropdowns:

=IF(NOT(ISBLANK(Override@row)),Override@row,FormResponse@row)

Good luck!

Kerry St. Thomas

Since the dropdown is restricted, I'm thinking your option is helper columns. So for the existing dropdown (that's surfaced on the form), include only the 2 values you want surfaced in your dropdown. Create a new dropdown column (I'll call this "Override") that's not surfaced on the form at all, but is available in the sheet itself, that has all 3 values. Finally, create a dropdown that basically flattens the two dropdowns:

=IF(NOT(ISBLANK(Override@row)),Override@row,FormResponse@row)

Good luck!

truyenh

May be Gia Thinh SmartForm can resolve your problem: SmartForm for Smartsheet | Smartsheet