1

Trying to populate the Website field on the Account if it's blank. Using an IF formula within a workflow to populate when ISBLANK(Website).

The WFR is working for the first field, which is Core Domain, but not if both Core Domain and Website is working. It should pull from LS Company Website...

IF(
ISBLANK(Website),
Core_Domain__c,
IF(
ISBLANK(Core_Domain__c),
LS_Company_Website__c,
NULL
)
)
Improve this question

1 Answer 1

Reset to default
2

You can use a BLANKVALUE formula:

BLANKVALUE(Website, BLANKVALUE(Core_Domain__c, LS_Company_Website__c));

It's often not required to use the IF statement, and this is one of those circumstances.

Improve this answer
8
  • For some reason that doesn't seem to be working either Core Domain or LS Company Website. The previous formula worked for Core Domain. For the workflow rule itself I'm using "Evaluate the rule when a record is created, and any time it's edited to subsequently meet criteria" and the Criteria is Website [Equal] null
    – goldk
    Commented Aug 10, 2018 at 2:50
  • @goldk How is it "not working?" What value are you getting? What are you expecting? It's kind of hard to work with a "not working" error.
    – sfdcfox ♦
    Commented Aug 10, 2018 at 3:03
  • There isn't an error. When I populate the Core Domain field (and Website is blank) and save the record it's not populating the website field. I run the same process and populate LS Company Website (and make sure both Core Domain and Website are blank) and save the record and still Website is not being populated.
    – goldk
    Commented Aug 10, 2018 at 3:05
  • @goldk It should be. Have you activated the workflow rule? Did you check the entry criteria? Have you tried creating a debug log? Did you activate the rule? Can we see the criteria for the rule?
    – sfdcfox ♦
    Commented Aug 10, 2018 at 3:06
  • 1
    @goldk can we see the criteria for the workflow rule? I suspect the problem is there.
    – sfdcfox ♦
    Commented Aug 10, 2018 at 3:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .