You need to sign in to do that
Don't have an account?
TheLearner
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
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
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
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
ITs working fantastic thanks