Set you WR Evaluation Criteria to
created, and any time it's edited to subsequently meet criteria
This would only trigger the change when the criteria is true and values validated were just set.
So there are 8 fields. These fields are normally empty, but get populated with $ amounts whenever those come in.
We have Assets associated to those fields.
So lets say Field 1 gets a $ amount, we need Asset 1 picklist to be switched to "Missing" because we need someone to get those Assets and then switch this picklist value to "In" because Assets are in.
I was wondering if there is any way to avoid all of these workflows and field updates and have one process/workflow that takes care of all of them at once, but I'm guessing that would require Apex?
Where would I utilize that code? Wouldn't the workflow still have to have a field update?
And that field update would have to be specific to a picklist correct?