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
SFDC n12SFDC n12 

Formula criteria workflow field update help

Hi,

I am trying to write a formula evaluates to true for a workflow based on "OR" Condition , its not doing the field update, is any thing wrog in my formula


 AND(


OR(
(How_many_years_have_you_been_in_business__c  > 3),
(Is_your_dealership_dedicated_to_RETAIL_a__c  = "Yes"),
(Is_the_dealership_lot_paved__c = "Yes"),
(Does_the_dealership_operate_from_a_perma__c = "Yes"),
(What_are_your_average_monthly_used_vehic__c  >= 50),
(How_many_front_line_ready_units_do_you_c__c >=50),
(What_percent_of_your_inventory_has_less__c >=90),
(What_percent_of_your_inventory_is_newer__c >=90),
(What_percent_of_inventory_has_a_selling__c >=90),
(Does_your_dealership_use_DealerTrack_and__c ="Yes"),
(Can_you_print_contracts_electronically__c ="Yes"),
(Does_your_dealership_have_a_dedicated_F__c ="Yes")
)
)


do let me know whats wrong in my formula validation

Thanks

Best Answer chosen by SFDC n12
Bhawani SharmaBhawani Sharma
You dont need AND(............) part.
OR(
How_many_years_have_you_been_in_business__c  > 3,
Is_your_dealership_dedicated_to_RETAIL_a__c  = "Yes",
Is_the_dealership_lot_paved__c = "Yes",
Does_the_dealership_operate_from_a_perma__c = "Yes",
What_are_your_average_monthly_used_vehic__c  >= 50,
How_many_front_line_ready_units_do_you_c__c >=50,
What_percent_of_your_inventory_has_less__c >=90,
What_percent_of_your_inventory_is_newer__c >=90,
What_percent_of_inventory_has_a_selling__c >=90,
Does_your_dealership_use_DealerTrack_and__c ="Yes",
Can_you_print_contracts_electronically__c ="Yes",
Does_your_dealership_have_a_dedicated_F__c ="Yes"
)

Which condition it suppose to meet?

All Answers

Bhawani SharmaBhawani Sharma
You dont need AND(............) part.
OR(
How_many_years_have_you_been_in_business__c  > 3,
Is_your_dealership_dedicated_to_RETAIL_a__c  = "Yes",
Is_the_dealership_lot_paved__c = "Yes",
Does_the_dealership_operate_from_a_perma__c = "Yes",
What_are_your_average_monthly_used_vehic__c  >= 50,
How_many_front_line_ready_units_do_you_c__c >=50,
What_percent_of_your_inventory_has_less__c >=90,
What_percent_of_your_inventory_is_newer__c >=90,
What_percent_of_inventory_has_a_selling__c >=90,
Does_your_dealership_use_DealerTrack_and__c ="Yes",
Can_you_print_contracts_electronically__c ="Yes",
Does_your_dealership_have_a_dedicated_F__c ="Yes"
)

Which condition it suppose to meet?
This was selected as the best answer
SFDC n12SFDC n12
HI,

All the below with "OR" CONDITION

 OR(
How_many_years_have_you_been_in_business__c  > 3,
Is_your_dealership_dedicated_to_RETAIL_a__c  = "Yes",
Is_the_dealership_lot_paved__c = "Yes",
Does_the_dealership_operate_from_a_perma__c = "Yes",
What_are_your_average_monthly_used_vehic__c  >= 50,
How_many_front_line_ready_units_do_you_c__c >=50,
What_percent_of_your_inventory_has_less__c >=90,
What_percent_of_your_inventory_is_newer__c >=90,
What_percent_of_inventory_has_a_selling__c >=90,
Does_your_dealership_use_DealerTrack_and__c ="Yes",
Can_you_print_contracts_electronically__c ="Yes",
Does_your_dealership_have_a_dedicated_F__c ="Yes"
)
Bhawani SharmaBhawani Sharma
Do you know which condition your record should meet ?
SFDC n12SFDC n12
any of the above conditions if its not true then the status field should be "unqualified"
Nilesh Jagtap (NJ)Nilesh Jagtap (NJ)
Hi Bharat,

Add alll conditions under single AND statment. You do not need to have OR.

If this helps mark this as best answer.

Thanks,
N.J
Bhawani SharmaBhawani Sharma
Then replace your formula with this:
AND(
How_many_years_have_you_been_in_business__c  > 3,
Is_your_dealership_dedicated_to_RETAIL_a__c  = "Yes",
Is_the_dealership_lot_paved__c = "Yes",
Does_the_dealership_operate_from_a_perma__c = "Yes",
What_are_your_average_monthly_used_vehic__c  >= 50,
How_many_front_line_ready_units_do_you_c__c >=50,
What_percent_of_your_inventory_has_less__c >=90,
What_percent_of_your_inventory_is_newer__c >=90,
What_percent_of_inventory_has_a_selling__c >=90,
Does_your_dealership_use_DealerTrack_and__c ="Yes",
Can_you_print_contracts_electronically__c ="Yes",
Does_your_dealership_have_a_dedicated_F__c ="Yes"
)