Thursday, 6 July 2017

Multiselect Picklist value inside formula feild


For a multiselect pickfeild to display inside the formula feild use INCLUDES

IF( INCLUDES(Multi_Select_PicklistFeild, 'String to Compare'),'1','-' )


Use ISPICKVAl for single picklist feild
  • ISPICKVAL—Compares the value of a picklist to a single value.
  • CASE—Compares the value of a picklist to multiple values.
  • TEXT—Converts a picklist value into a text value so that you can work with the value in functions that support text value, such as CONTAINS. (Available in only flow formula resources, formula fields, validation rules, and workflow field updates.)