Changing an older cell based on criteria from a newer cell
Looking for a little assistance with a formula (or workflow), if even at all possible.
I have a row of data with a Date, a Room and a Status of “Conditional Pass”.
When that same Room gets checked again at a later Date, has a Status of “Pass” and a new row is added, is it possible to change the original Status entry to something else, like “Pass – UPDATE”.
Screenshots are attached to help illustrate what I am going for.
Any and all assistance is greatly appreciated!