Ability for PM's to select which projects they want to receive a status update request e-mail
On an ad-hoc basis I need project managers to be able to select which project(s) they want to receive the status update request so they can update accordingly.
Currently In my dashboard I give them access to a separate "project selection" sheet containing the project list (linked in from the master data sheet) and a "Yes/No" dropdown cell against each project (this cell is linked out to the Master Date sheet) ---- so when they select "YES" for a particular project the Master data sheet would see the change from NO to YES and by using the workflow automation send out the update request.
After the update request has been initiated I need to reset the YES/NO selection cell back to NO.
I think I am getting lost in the workflow automation and the sequence of when things happen and the interactions between the "selection" sheet and the master data sheet which sends out the request.....
I do not want to give them access to the main data sheet - which is where I believe the request need to be activated from.....
There must be a simple way for them to select from a list which projects they want to update?