function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KyriacosKyriacos 

Multiple Formula Field Error

Trying to create a mulitple if Statement however I cannot see where I am going wrong:

current formula which works:

IF(FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ,True , False)

When I try to add another parameter I get an error message:

AND(
IF(
Priority_Level1__c = "P4",
FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ,True , False
)
)
Best Answer chosen by Kyriacos
Maharajan CMaharajan C
Hi Kyria,

Try this,

IF(
AND(Priority_Level1__c = "P4",FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ),True , False )

Can you please Let me know if it helps or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
Raj

All Answers

Raj VakatiRaj Vakati
Try this
  
AND(
IF(Priority_Level1__c = "P4",
IF(FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ,True , False) ,FALSE),false)

 
Maharajan CMaharajan C
Hi Kyria,

Try this,

IF(
AND(Priority_Level1__c = "P4",FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ),True , False )

Can you please Let me know if it helps or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
Raj
This was selected as the best answer