+ Start a Discussion
TheLearnerTheLearner 

writing new forumla field

HI Experts,

i need to write a forumla like this, could you guys me shape for this please

IF Date Assessed/ Rejected = NULL AND If (Related) tRIIO_Application.Days Left for Approval <= 0 Then
Forecast D+12 = Today() 
IF Date Assessed/ Rejected = NULL AND If (Related) tRIIO_Application.Days Left for Approval > 0 THEN
( TODAY() + Application_Ref__r.Days_Left_for_Approval__c ))
ELSE
Forecast D+12 = Date Assessed/ Rejected,

 existing forumala: IF( Application_Ref__r.Days_Left_for_Approval__c >=0, TODAY() ,( TODAY() + Application_Ref__r.Days_Left_for_Approval__c ))

could any one tell me how to write for this , thanks in advance
Best Answer chosen by TheLearner
Bhanu MaheshBhanu Mahesh
Hi TheLearner,

Lets suppose API  name of Date Assessed/ Rejected field is Date_Assessed_Rejected__c(change this accordingly)

Try below formula

IF(ISBLANK(Date_Assessed_Rejected__c),IF( Application_Ref__r.Days_Left_for_Approval__c <=0, TODAY() ,( TODAY() + Application_Ref__r.Days_Left_for_Approval__c )),Date_Assessed_Rejected__c,)

Mark this as "SOLVED" if your query is answered.

Thanks & REgards,
Bhanu Mahesh

 

All Answers

Bhanu MaheshBhanu Mahesh
Hi TheLearner,

Lets suppose API  name of Date Assessed/ Rejected field is Date_Assessed_Rejected__c(change this accordingly)

Try below formula

IF(ISBLANK(Date_Assessed_Rejected__c),IF( Application_Ref__r.Days_Left_for_Approval__c <=0, TODAY() ,( TODAY() + Application_Ref__r.Days_Left_for_Approval__c )),Date_Assessed_Rejected__c,)

Mark this as "SOLVED" if your query is answered.

Thanks & REgards,
Bhanu Mahesh

 
This was selected as the best answer
TheLearnerTheLearner
Hi Mahesh,

ITs working fantastic thanks