Formula to Refresh ONLY if Status is Open
Hi all! First of all, thanks for your assistance. I have a sheet, and I want to create a formula to another (a simple VLOOKUP). However on my initial sheet where the formula resides it will be based on the Status. If the status is Open, I would like the formula to make any updates. However if the record has a Closed status, I would like the record to NOT update at all. Is this even possible?
Will I need to create an IF Statement within my VLOOKUP and have 2 PM fields (Original and NEW)? Stating that IF Status = Closed, then Original PM, If Status = Open, then New PM? That is the only way I can think of that may work. I understand that I cannot have a value and a formula occupying the same cell.
Project Analyst | Core Quality Services (QMS Transformation)
Help Article Resources
Check out the Formula Handbook template!