For example, I have a formula that determines the name of a sales rep based on the Sales_Rep_Code (The names can't be in the system) and every time the sales rep changes I have to go back in every single report that I have and make changes.  (Which is a ton)

 

If sales_rep_code = "1" then "John Smith"

else If Sales_rep_code "2" then "Jane Smith"

etc

 

Is there a way to create a formula's or function where I can just change this once and it filter down to all my reports?