Some of my columns in my custom list have dependent logic.
Q1: "Does your submission affect customers?"
Q2: "If so, how?"
I would like Q2 to only show up if the user clicks "Yes" for Q1. I've tried setting up advanced column permissions, and when I click "No" for Q1, Q2 gets hidden. However, because Q2 is required, the form refuses to save.
Is there any way around this?