Sign Up ›
  • Cassie Cafferty
  • NEWBIE
  • 0 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
3 replies

Field formula results from another field

Please help, I need to update the following formula for Parent IDN field:
IF (ISBLANK(GP_Roll_Up_Sub_Type__c), "", 
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "AESYNTIX"),"AESYNTIX",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "BEAUMONT"), "BEAUMONT",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PIPELINE"), "PIPELINE",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "REGSURG"), "REGSURG",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "SPOG"),  "SPOG",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "SUTTER"), "SUTTER",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "VANGUARD"), "VANGUARD",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "YANKEE"), "YANKEE",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PROV2"), "PROV",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PROVAFF"), "PROV",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PROVAFF2"), "PROV",GP_Roll_Up_Sub_Type__c))))))))))))

Currently if my GP Roll Up Sub Type field contains one of the above, the correct response is placed in the Parent IDN field, if blank, then both remain blank, I would like to add if the value is different from blank or any of the above, to put the same data in Parent IDN field. Ex., if the GP Roll Up Sub Type field contains MED, I want MED to display in the Parent IDN field.
3 replies

Field formula results from another field

Please help, I need to update the following formula for Parent IDN field:
IF (ISBLANK(GP_Roll_Up_Sub_Type__c), "", 
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "AESYNTIX"),"AESYNTIX",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "BEAUMONT"), "BEAUMONT",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PIPELINE"), "PIPELINE",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "REGSURG"), "REGSURG",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "SPOG"),  "SPOG",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "SUTTER"), "SUTTER",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "VANGUARD"), "VANGUARD",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "YANKEE"), "YANKEE",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PROV2"), "PROV",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PROVAFF"), "PROV",
IF (CONTAINS (GP_Roll_Up_Sub_Type__c, "PROVAFF2"), "PROV",GP_Roll_Up_Sub_Type__c))))))))))))

Currently if my GP Roll Up Sub Type field contains one of the above, the correct response is placed in the Parent IDN field, if blank, then both remain blank, I would like to add if the value is different from blank or any of the above, to put the same data in Parent IDN field. Ex., if the GP Roll Up Sub Type field contains MED, I want MED to display in the Parent IDN field.