Alert to send email
We setup an Alert in our sheet. The Alert is the closing date for Tenders. The Estimator who added this Tender to the sheet needs to receive an alert 3 days prior to the closing date. There are different Estimators for each Tender. Each Tender is listed on a row. How do we ensure the Alert is only sent to the Estimator that added it to the sheet?
Also, we have a RGB column that highlights the status for the job. Yellow hasn't started, Green has started, Red hasn't started after the start date. Blue is complete. When someone has selected Blue in the Job Status column, it means it is finished. How can we link the columns in the same sheet so that when a complete date has been added, the Job Status column automatically turns the button blue?