+ Start a Discussion
cldavecldave 

If these 2 fields = Blank return Image formula

Hi as title indicates i'm trying to make a condition that if 2 specific fields = blank or Null for a flag to appear.

Here is formula i've managed so far, but seems i have an error, as blank or not it returns green flag.

if(ISNULL(Account__r.Banking_Username__c + Account__r.Banking_Password__c  ) , IMAGE("/img/samples/flag_red.gif", "red"), IMAGE("/img/samples/flag_green.gif", "green"))

If someone could help me with Syntax I would greatly appreciate it

thx
Best Answer chosen by cldave
Coco_SdyneyCoco_Sdyney
try this:
if(ISBLANK(Account__r.Banking_Username__c) & ISBLANK( Account__r.Banking_Password__c  ) , IMAGE("/img/samples/flag_red.gif", "red"), IMAGE("/img/samples/flag_green.gif", "green"))

All Answers

Coco_SdyneyCoco_Sdyney
try this:
if(ISBLANK(Account__r.Banking_Username__c) & ISBLANK( Account__r.Banking_Password__c  ) , IMAGE("/img/samples/flag_red.gif", "red"), IMAGE("/img/samples/flag_green.gif", "green"))
This was selected as the best answer
cldavecldave
Thx!