Hi Everyone,

I'm stuck up with a problem here and I hope I'll get some help here. I want
a conditional validation done on one of my cells. This is how it goes. I'm
working on a report that spans multiple teams across multiple locations. The
person running the report will have to select the location from a list
validation. Now, based on the location selected, I want another list
validation for the team field. This list should carry only the teams active
in the selected location. Is there any way this can be done without involving
programming?

Thanks,

Sam