You need to sign in to do that
Don't have an account?
Need assistance in creating a complex formula field
Hi guys!
I'm trying to create a formula text field that I had on an existing report. I'd love the text formula field to output Majors Priority if it meets the following criteria:
Filtered By:(1 AND 7) AND 6 AND (2 OR 3 OR (4 AND 5))
1. Campain Member Owner Sub-Sub-Team contains account management,client sales
2. Is Cloud's Most Senior Decision Maker? equals True
3. Title contains Channel,Partner,Agent,Sales,Vendor,Alliances,Reseller,Enablement,Customer Service,Volunteer Services,Distribution,Marketing,Analytic,Analytics,Data,Machine Learning,Business Intelligence
4. Title contains Manager,Director,Dir,VP,SVP,CHRO,CLO,Mgr,Vice President,V.P.
5. Account Software/Solutions Purchased does not contain blank
6. Campain Member Owner Sub-Sub-Team does not contain smb
7. Campain Member Owner Sub-Sub-Team contains majors
Information that you would probably need. Title is a text field. Is Cloud's Most Senior Decision Maker is a formula checkbox field. Account Software/Solution Purchased field and Campain Member Owner Sub-Sub-Team are formula fields that just outputs text.
Any help to get me started on this would be greatly appreciated. Thanks in advance.