Skip to main content

The use case is this....

We can sell up to 59 types of services/products to our customers.

There is a custom object with a checklist for these 59 items (a picklist for each item) where each one states, whether we are working, have secured, or the status is unknown.  Is there a way to count these 59 fields which all have the same global value set, and see the result on the same record, of how many are working, how many are secured, and how many are unknown?  

 

I know I can pull reports from the opportunities to see how many we are working on and have secured, but it is important for the client to see out of the 59 items possible, how many they have spoken to the client about. 

 

It's been a long day and I just can't think of a way right now!

 

@Steve Molis

If you can come up with a formula for this, I'll owe you a beer!

12 answers
  1. Jun 22, 2021, 7:49 PM

    Crap!  

     

    CASE([Object].Picklist_A , "Working",1,0) +

    CASE([Object].Picklist_B , "Working",1,0) +

    CASE([Object].Picklist_C , "Working",1,0) +

    CASE([Object].Picklist_D , "Working",1,0) +

    CASE([Object].Picklist_E , "Working",1,0)