Folmula Help

Where is the error in this formula

or(isInList($riskpercentage_c,createList(25,50,75,100),
or(isInList($sales_stage,createList("Sale Closed- Lost","Pending_Cancellation"),
or((isInList($lost1_c,createList("Product Performance")AND(not(equal($lost3_product_c,""))))))))))

What I want to do is make the field required if Risk Percentage is a >25 or Sales Stage is either Sales Closed Lost or Pending Cancellation or if lost1_c is Product Perfomace and lost3_product_c is not filled in.

Thanks

Parents

0 Andre Serrazina 5 months ago
Hello Olivia,

I think it's easier if you just create one or() with all the conditions there.
I believe I got all your requirements on this formula, please make sure the strings are correct:

Fullscreen
1
2
3
4
5
or(
greaterThan($riskpercentage_c,25),
isInList($sales_stage,createList("Closed Lost","Pending_Cancellation")),
and(equal($lost1_c,"Product Performance"),equal($lost3_product_c,""))
)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
or( greaterThan($riskpercentage_c,25), isInList($sales_stage,createList("Closed Lost","Pending_Cancellation")), and(equal($lost1_c,"Product Performance"),equal($lost3_product_c,"")) )

Let me know if this works.
Cheers,

André
0 Olivia Forde 5 months ago in reply to Andre Serrazina

I get this error greaterThan: The parameter at index 0 must be of type number.

Field riskpercentage is a dropdown list.

I have fixed that bit but it is still not working for the last condition. It needs to be only required if these two are both true $lost1_c,"Product Performance"),equal($lost3_product_c,""

Reply

0 Olivia Forde 5 months ago in reply to Andre Serrazina

I get this error greaterThan: The parameter at index 0 must be of type number.

Field riskpercentage is a dropdown list.

I have fixed that bit but it is still not working for the last condition. It needs to be only required if these two are both true $lost1_c,"Product Performance"),equal($lost3_product_c,""

Children

No Data