One of my teams uses a sheet to track to the status of products in every state, with a column containing a status dropdown list for each state (Requested, In Progress, On Hold, Completed, etc.). We recently implemented a form for our internal clients to submit requests. As part of this form, we have two questions pertaining to the states: 1) Are you requesting all 50 states? (Yes/No) radio buttons, and 2) If not, select the states you're requesting: (this is a multi-select dropdown).
My goal: When a form is submitted, the sheet will automatically change the states being requested to "Requested". This is easy for the "All 50 States" selection - a single automation. However, for the multi-select dropdown, I'm having to do a separate automation for each of the 50 states because a single automation has a limited number of conditions allowed. The thing making this frustrating is that the cells needing to show as "Requested" are dropdowns that the team needs to be able to update later on. These columns for the state statuses are already built into reports and dashboards.
Is there an easier way to do this? I feel like I'm missing something obvious here, or there's a different way to think about this altogether.
Example of the result I'm looking for, with the state columns being a single select dropdown:
