Skip to main content
Topics#Data ManagementColin Samson 的问题
Colin Samson (Evolve) 提问于 #Data Management
2011年5月23日 06:41

case formula

I am using a CASE formula to update my probability. This value is calculated based on two picklist field variations, eg picklist 1 equals B and picklist 2 equals C. How can achieve this in one CASE formula? The problem I'm having is that I have two field updates (one that returns the 'else' value, and then the field update that meets other criteria in the other CASE formulas.
1 个回答
  1. Sonali Bhardwaj
    2011年5月23日 09:18

    Your Q's second part is not clear to me. But for the first part you can write a formula like : 

     

    CASE( Text(Pick1) +'&' + Text(pick2) , 'B&C, 'PASS', 'FAIL')

     

    You can concatenat two pick list values having "&" (or any char you want) between. If value is equal to B&C then return Pass otherwise FAIL.

     

    Hope this will help.

撰写回答...
0/9000