Hello,
I am currently working on a form with seven dropdown fields. Each field has 2-3 dropdown options. I also have a dropdown field with two options (Approved and Notification) that I need to be automated. I need to set the form up so when a user selects certain options from the seven dropdown fields, the Approved/Notification dropdown field automatically populated to Approved, whereas other options from the seven dropdown fields will automatically populate the Approved/Notification field to Notification.
I've seen some formulas online that might be able to help, though I'm unsure due to the large number of dropdown fields/options the user can choose from. Is there a way to perform this task? I can attempt to go into greater detail if necessary.
Thank You,
Ben