I am creating a training tracking sheet for my work. The input will constantly be updated by employees entering the date that they execute the training. When they do this the clock resets to 0 days. Once they reach 30 days I have function to trigger a 1 and would like to have an email sent to their line manager to remind them to sign up their employee for training. Once they hit 60 days the trigger would change from 1 to 2 and would like another email sent reminding them that they are now over 60 days and need to schedule training. and finally once they go 90 days+ the trigger changes from 2 to 3 and would like for them to have one final email stating they are 90 days out and please schedule training asap.
Column A = Employee Name, Column B = Most recent training, Column C = Their Line managers name, Column D = Today's date, Column E = days since last training, Column F = Email trigger number (0=30 days or less, 1 = 30 to 60 days out, 2 = 60 to 90 days out, 3 = 90+days), Column G = Their Line Managers Email Address.