function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Marcio Zima.ax1538Marcio Zima.ax1538 

How to set pick list value automatically? (Chart)

There is a formula field "Y__c" that returns 'High', 'Medium' and 'Low'. It's using a workflow rule calculation that evaluate when It's saved.

 

I need a Chart with color red (high), yellow (medium) and green (low). So I create a picklist to set the colors. This picklist have a field update and a workflow to each status that set the value according to "Y__c".

 

The problem is the execution order of workflows. Picklist field is not updating in the same time of "Y__c". Just after a second click on save. How to set pick list value automatically in this case to use Chart? Apex?