Forum Discussion
Existing formula but need to add an additional site from another sheet
I need help with an existing formula on a spreadsheet. I added another site, school 4 (sheet 3), to an existing dropdown menu on sheet 1. When I then start using school 4 from the dropdown menu on sh...
Thank you; I needed to add those areas to the formula on Sheet 1, but didn't know how to do that for school 4. The formula from sheet 1 only exports data from Sheet 2 for Campus 1, 2 and 3. I just couldn't figure out how to recalculate and update formula on Sheet one for all the cell.