function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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.