I need a formula to clear contents in a field if the date in another cell is in the past.
For our process documentation review cycle, we have a column for Date of Next Review. There is a column next to it, Reviewed Process, that has a dropdown to indicate if the document has been uploaded to our Sharepoint site. If the date of next review is in the past, I need the contents in the Reviewed Process column to clear. That way when the process is reviewed, our team will update the Date of Last Update column, which will in turn update the Date of Next Review. We need them to select from the dropdown that the process document has been uploaded.
If this isn't possible, do you have another suggestion that would help us to prompt our team to ensure documents are uploaded after reviews are complete?
Thanks a million for your help!
Help Article Resources
Check out the Formula Handbook template!