I have a master roster which I can see all my employees, there are trainee ranks these trainees must go with a full employee all the time and the full employee then submits a form "Google Form" on whether they think they should be promoted. I then have another sheet which imports the form responses. Is there a way that when the trainee becomes a full employee their reports disappear from the imported form responses
Solved by T. W. in 21 mins