@Steve Molis add 1 to my tab.
Users needed to report by Parent Account but also include the parent account within the grouping. Ultimate Parent to the rescue!
@Steve Molis add 1 to my tab.
Users needed to report by Parent Account but also include the parent account within the grouping. Ultimate Parent to the rescue!
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!
If you can come up with a formula for this, I'll owe you a beer!
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)
Hi!
I need assistance with a formula. I am trying to create one where IF date field contains 2015 AND status is PICKVAL "Actual", THEN show amount field.
This is what I have and I'm getting an error.
(IF(CONTAINS( Booking_Date__c , "2015"))
and
IF(ISPICKVAL(Status__c , "Actual") ), Booking_Amount__c , 0)
The below worked for displaying the amount based on Status.
IF(ISPICKVAL(Status__c , "Actual") , Booking_Amount__c , 0)
Thank you in advance for your help!!