Set dropdown based on values in row
Hello, I'm trying to set values in a dropdown list using a formula (or any other suggestions) based on the columns in the same row.
For example, I have a drop down list titled Cities that allows multi select with the values Chicago, Boston, Atlanta as options.
I have three columns on the same sheet named Chicago, Boston, Atlanta. In each row, the word Yes or No is added for each city. I'd like to summarize that into check boxes in the drop down.
So if Chicago, Boston and Atlanta are all yes, I'd like the drop down to have all three cities checked.
If Chicago is set to yes, but Boston and Atlanta are No, I'd like the drop down to have a check in Chicago and no checks in Boston and Atlanta.
Thanks for any advice.
Help Article Resources
Check out the Formula Handbook template!