Hi, 

I need some help with a formula. 

I need to create a "Client Due Date" field. This formula should be based off (the Submission date field) Submission_Date__c PLUS a number that is selected from the picklist value from the Processing Days (Processing_Days__c) field which includes the values: 8.9,10,11,12,13,14,15 

Could someone please help me out on this one?

Thanks
Tori

Hi, 

I need some help with a formula. 

I need to create a "Client Due Date" field. This formula should be based off (the Submission date field) Submission_Date__c PLUS a number that is selected from the picklist value from the Processing Days (Processing_Days__c) field which includes the values: 8.9,10,11,12,13,14,15 

Could someone please help me out on this one?

Thanks
Tori

Hi All,
I have a senariou like this, i have  Created Date field(custom field)  and   Expire Date __c (Formal Datefield). For Example Created date is 6/09/2016 then the Expiredate__c should add 15 working days(30/06/2016) (exclude sunday and saturday) to CreatedDate__C.
My logic for this is :
 CASE( MOD( date - DATE( CreatedDate__C ), 7 ),
3, date + 2 + 15,
4, date + 2 + 15,
5, date + 2 + 15,
6, date + 1 + 15,
   date + 15
)
But it is not working proparly. Any one please help me to over come this.

Thanks and Regards,
Raji

So I want to display a flag if a checkbox is checked. I have tried:

 

IMAGE(
IF(Account.Customization__c ,
"checkbox is checked","/img/samples/flag_red.gif"),
"")

 but the flag does not appear. If I try;

 

IMAGE(
IF(Account.Customization__c ,
"checkbox is unchecked","/img/samples/flag_red.gif"),
"")

 the flag appears.

 

What am I doing wrong. What is the right formula for displaying my red flag when the checkbox is checked please?