Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Tori Sansom 9Tori Sansom 9 

Formula based off a date field plus picklist value

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
Best Answer chosen by Tori Sansom 9
Akhil AnilAkhil Anil
Hey Tori,

What's the data type of your Submission Date field ? If it's a Date field then your formula would be simply this
  
Submission_Date__c + VALUE(TEXT(Processing_Days__c))

If it's a Datetime field then your formula would be like this
  
DATEVALUE(Submission_Date__c ) + VALUE(TEXT(Processing_Days__c))

Kindly mark it as an answer if it works for you.

All Answers

Tori Sansom 9Tori Sansom 9
Thank you, I aready tried this but I get an error as Processing days is a picklist field? 
Tori Sansom 9Tori Sansom 9
So sorry but i'm still getting an error here... 
User-added image
Akhil AnilAkhil Anil
Hey Tori,

What's the data type of your Submission Date field ? If it's a Date field then your formula would be simply this
  
Submission_Date__c + VALUE(TEXT(Processing_Days__c))

If it's a Datetime field then your formula would be like this
  
DATEVALUE(Submission_Date__c ) + VALUE(TEXT(Processing_Days__c))

Kindly mark it as an answer if it works for you.
This was selected as the best answer
Tori Sansom 9Tori Sansom 9
Thanks Akhil, this works perfectly now.