This message was deleted.

Since it is a non stored field with a saved search as source, can't you just mimic that logic in your new saved search instead of creating a new field that shows the same data? It doesn't seem efficient or reliable.

If you want to store the value you need to use the after record submit trigger in a workflow to copy the value into your stored field Any other trigger won’t work because the saved search has no data until the record is submitted to the database

@mesper we are attempting to use this field in a formula so putting it soley in the new saved search isnt helpful

You can do it with a scheduled workflow. On WF definition under Schedule, you can select a saved search that returns the list of Work Orders that you want to update.

@Kendra Borkholder Yes, but since the field on your WOs is based on a saved search, you can copy that saved search and use it as a basis for your new saved search. Instead of populate new fields that slow down the system and makes things more complicated because you create redundance in your data.