• Md Abdul Mohit
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I have created a formula field. I want to show a text field value if it is not blank.
If it is blank then show a picklist field if that picklist is not blank.
If the picklist field is also blank show a different text field.
I have tried the below formula.
 
IF(NOT(ISNULL(TextField)), TextField, IF(NOT(ISBLANK(TEXT(Picklist))), TEXT(Picklist), TextField_2))


When there is a value in TextField, it is updating correctly. But if is blank and there is a value in the Picklist field it is not showing.