You have to


  1. Turn 'Calculated Field' off
  2. Copy logic into a before update/insert business rule
  3. Run a once off script on all in flight tickets to populate the field

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022