Sign Up ›

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

formula to render Yes or No

Hello, 

I have a formula that produces an outcome of either YES or NO. 

This formula will produce a NO if any of the selections are made. 

A YES would be produced if additional picklist items are selected (not shown). 

What i'm trying to do, is somehow make this formula shorter if possible? 

Would anyone know how to condense it? 

thanks!

  
IF(
OR(
AND(
NOT(ISPICKVAL([Account].productA, "")),
NOT(ISPICKVAL([Account].productA, "No Location"))
),
AND(
NOT(ISPICKVAL([Account].productAB, "")),
NOT(ISPICKVAL([Account].productAB, "No Location"))
),
AND(
NOT(ISPICKVAL([Account].productXY , "")),
NOT(ISPICKVAL([Account].productXY , "No Location"))
),
AND(
NOT(ISPICKVAL([Account].productEE, "")),
NOT(ISPICKVAL([Account].productEE, "No Location"))
)
), "Yes", "No")

 
Best Answer chosen by HNT_Neo
Santosh Reddy MaddhuriSantosh Reddy Maddhuri
CASE( OR([Account].ProductA,[Account].ProductAB,[Account].ProductYX,[Account].ProductEE),

 "","Yes",
 "No Location","Yes",
"No"

)

Try This