RAID Log Date Value Locking per column when status changes
Hello everyone, I have tried to find the best answer for this but I see too many threads and different responses. If anyone could help as I am new to this.
I am only looking to lock in a date value on 2 columns whenever there is a status change, from when an issue is raised and then resolved.
I know there is a record a date automation but that would only work for the date opened columns and not the resolved one? Am i correct in that? Perhaps there is a conditional format or function i may need to use.
I have seen someone talking about using a lock formula method but it is quite confusing to me
Would anyone be able to advise on this?
Thank you !!
Help Article Resources
Check out the Formula Handbook template!