Post

2 followers Follow
0
Avatar

Update Custom Field (KPI field)

 

I want to create kpi field that is updated based off values in custom fields.

 

i.e,.

if custom field A is greater than custom field B i want to update a KPI field to put a picklist item as "red"

Colin Knoll Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Hello Colin,

Your formula should look something like this: If($C_FieldA > $C_FieldB, 'Red', 'Green')

$C_FieldA and $C_FieldB are the API names of the fields. 'Red' is the color if condition is TRUE and 'Green' is the color if condition is FALSE (provided both 'Red' and 'Green' are valid options in the picklist).

Please let me know if this helps.

Roland Pumputis 0 votes