In Account object I am having a formula field with address details and its related with other object (Lookup field), if any update happens means it should be reflected in account object based if the status is Active otherwise the previous value should be reflected.
Is it possible?