Secondary Logic in Forms

Does anyone know if there is a way to use secondary logic in forms? Basically we are trying to have three drop downs, first is the supervisor where they go in and select their name, once they select their name we want the next drop down to only include their employees, and then the third is approve or deny. So far all I can get it to do is...if Supervisor is then show employee but want employee to be specific to that supervisor, so out of 147 employees the supervisor might only have 10 of them.

Simply put...If supervisor is this then employee is this...


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!