Prevent volatile NOW function from overwriting static timestamps by using IF logic or VBA to update only when a specific trigger cell changes.