Logic and summary
We have 400 locations managed by approx 30 managers. I am trying to use logic to build a form that when manager 1 chooses their name they only see sites relating to them. To achieve this i have created columns with a drop down for each manager in my sheet.
As these entries come into the sheet via form entries they go under the relevant managers column, so entries can be spread across 30 columns with the location name
Where i need help is rolling this up onto another sheet which will pull through the last entry per site.
Is this possible?
This is the feed in form
This is the summary sheet
Any help or guidance would be greatly appreciated
Help Article Resources
Check out the Formula Handbook template!