Formula Builder - check for multiple conditions

I want to check for multiple conditions in a formula - this is what I have tried

equal($sales_stage,"Sale Closed- Lost")
and
greaterThan(strlen($lostreason1_c),0)
and
greaterThan(strlen($lostreason2_c),0)
and
greaterThan(strlen($lostreason3_c),0)

but I get this error

equal: Syntax Error (Improperly Terminated String ') and greaterThan(strlen($lostreason1_c)')32 72

Parents

0 Frédéric Rinaldi over 2 years ago
Hello,

the syntax will be more like

Fullscreen
1
AND(equal($sales_stage,"Sale Closed- Lost"),greaterThan(strlen($lostreason1_c),0),greaterThan(strlen($lostreason2_c),0),greaterThan(strlen($lostreason3_c),0))
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
AND(equal($sales_stage,"Sale Closed- Lost"),greaterThan(strlen($lostreason1_c),0),greaterThan(strlen($lostreason2_c),0),greaterThan(strlen($lostreason3_c),0))

Fred

Reply

0 Frédéric Rinaldi over 2 years ago
Hello,

the syntax will be more like

Fullscreen
1
AND(equal($sales_stage,"Sale Closed- Lost"),greaterThan(strlen($lostreason1_c),0),greaterThan(strlen($lostreason2_c),0),greaterThan(strlen($lostreason3_c),0))
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
AND(equal($sales_stage,"Sale Closed- Lost"),greaterThan(strlen($lostreason1_c),0),greaterThan(strlen($lostreason2_c),0),greaterThan(strlen($lostreason3_c),0))

Fred

Children

0 Olivia Forde over 2 years ago in reply to Frédéric Rinaldi

Hi Fred

This gives an error

AND: No such function defined

Is there somewhere in Sugars docs where I can find these functions - the information I can find is very limited to simple single functions