...additionally, 'all tasks' includes ANY row of data on each sheet that has the WHO in Column A. This includes tasks under Ordering (which tells the team what needs to be delivered to site soon), and Current Tasks (which let's us all know what stage the build is at). There will not be a WHO under Notifications. I figured that once you got the code happening for Current Tasks, I'd be able to add other areas of the sheet to the search.
Bookmarks