I'm working on a sheet that will help my team track permits in cities across the United States. There are 4 projects that each have specific needs. My idea was to create a drop down to select the state and a vlookup to search the city under the state. I want my team to be able to select their checkbox and have the check status linked to the searched city. IE we should be able to select the box when we know a permit is needed and lookup the city again to know we have needed it before. Any ideas? Please see attached sheet.
https://docs.google.com/spreadsheets/d/1bka6k582_cLCCMU1MToiWILPfOIBS9KjGtxaDqRgPl4/edit#gid=0
Aucun commentaire:
Enregistrer un commentaire