function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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!