change word in cell when date in another cell is past
We have a safety sheet that has all the names of all who have been trained in a certain safety procedure, we have issued them a certificate but that certificate will expire in 3 years. On the sheet we have a trained date column a retrain date column and the 3rd column called status.
In the status column we have it set as a dropdown with "valid" or "needs retraining", when entering their information in the row we manually select "valid", what I would like to do is when the retrain date column reaches the 3rd year date I would like the cell that had "valid" in it to change to "Needs Retraining".... i have tried workflows but just can't seem to make the status column cell change to "needs retraining".
Please help me, thanks in advance.
Help Article Resources
Check out the Formula Handbook template!