Skip to main content
Topics#FormulasArvind Kumar Singh 的问题
Arvind Kumar Singh (TATA Consultancy Services) 提问于 #Formulas
2019年9月17日 07:46

Want to highlight ETA field with specific color on list view when ETA field is updated once and if field updated twice than it should be highlighted with another color

Hi,

My requirement is to get below color indicators on an field-

  • ETA Changed 1st Time – Green 
  • ETA Changed 2nd Time – Yellow

Anybody please assist 

1 个回答
  1. Dhanyashree Nagesh (Trekbin)
    2019年9月19日 02:19
    Hi AK Singh,

    I don't think if we can change the color of field value. You need to find some workaround to achieve this.

    What you can do here is you can create a formula field to display some color flag. Something like in this blog https://blog.ijasoneverett.com/2017/08/adding-custom-color-flag-fields-in-salesforce/

    To track the number of times ETA field is changed, create a number field 'ETA change count' which is hidden from page layout. Update this field with increment from workflow rule whenever ETA field is changed.

    Then in formula field, based on 'ETA changed count' show color flag. 

    IF( ETA_changed_count__c = 1, IMAGE("/img/samples/flag_green.gif", 'Green') , IF(ETA_changed_count__c > 1, IMAGE("/img/samples/flag_yellow.gif", 'Yellow'), '') )

    Let me know if you have any question on this.

    Thanks,

    Dhanya
撰写回答...
0/9000