Skip to main content
Group

The Temple of Shannon Hale

An appreciation and place of worship for the Goddess of Salesforce Formulas, Shannon Hale.

Did you know? Salesforce flow is totally awesome + new! Join #AdminHour: Your Flow Builder Questions Answered with @Shannon Hale to see and learn it on Thursday, April 4, 2019 at 10amPT/1pm ET! Bring ?s, your sandbox, + tell a friend! SPECIAL SECRET SURPRISES IN STORE! Register here: http://www.longshoreconsulting.com/adminhour.html Can't attend live? While the focus is on Q&A this time, you can still register at the same link and be sent the replay (use the same link if you're seeing this after 4/4/19 as well).

Register for #AdminHour: Your Flow Builder Questions Answered with Shannon Hale!

6 comments
0/9000
6 comments
0/9000

I am creating a formula field to determine if one date field is not equal to the other.  I having an issue when one of the dates is blank.  It is not recognizing the blank date as not being equal to the field with a date.  Can you help?

9 comments
  1. May 20, 2016, 2:20 AM

    awesome-- good tip thanks SteveMo!

    Shannon, you can also write it like this (I find this format easier to read personally)...

    Customer Requested Date <> Delivery Date

    ||

    (ISBLANK(Customer Requested Date) && NOT(ISBLANK(Delivery Date)))

    ||

    (NOT(ISBLANK(Customer Requested Date)) && ISBLANK(Delivery Date))

0/9000

Happy International Women's Day everybody! Today's a day where we celebrate the social, economic, cultural, and political achievement of women.

 

More info: http://www.internationalwomensday.com/

 

In celebration of today, I want to spotlight some of our amazing women-focused groups in the Community!

 

Workforce Development Programs led by @Mary Scotton

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009NXPCA2

 

@RAD Women - Program Information (PUBLIC) led by @DON'T USE Kieren Jameson

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F930000000fxeJCAQ

 

Women In Tech Diversity

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F930000000fxoNCAQ

 

Women Who Salesforce - Mentoring Circle led by @Jessica McGuire

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009Ni2CAE

 

Some of our amazing Women In Tech User Group leaders

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001qyoCAA

 

Tag someone in the comments below whom you'd like to shoutout today.

15 comments
0/9000
I'm hoping that Salesforce will continue to allow this community to flourish even after @Shannon Hale heads over to @Skuid next week.
1 comment
0/9000

Hi,

I'm not sure if this is a workflow, validation rule or trigger.

I've created a custom field on the User detail page and I need to have this field populated everytime I create a new User.

Any advice?

Thank you,

O

7 comments
  1. Apr 17, 2015, 6:18 PM

    Hi All,

    Question, I need either a validation rule or workflow alert for the following:

    We have Users who close cases without saving them with internal comments.

    I'd like to be able to prevent them from closing a case unless they have made a comment on the case.

    Does that make sense?

    Thank you,

    Orchid

0/9000

Hi,

I'm working on a formula, which ideally I would like for to output color in its respective field.

IF (BSC_Last_12_Months__c > 30000,"Platinum",

IF(BSC_Last_12_Months__c > 15000,"Gold",

IF(BSC_Last_12_Months__c > 2500,"Silver",

IF(BSC_Last_12_Months__c > 0,"Bronze",NULL))))

I have the hex codes for the colors I need:

#e5e4e2

Plat

#ffd700

Gold

#c0c0c0

Silver

But, can't seem to make it stick. I've seen also other posts suggesting that I use image/files/servlets? No idea where I can get those.

Any help would be greatly appreciated.

Thank you!

Orquidea

10 comments
0/9000