Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Help with two formulas - Thanks!

Topic Labels: Formulas
916 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Yuli_Zingerman
4 - Data Explorer
4 - Data Explorer

Hi all, I’m looking to create two formulas:

First: collecting all different contacts under the same account and apply a % based on how many contacts from the organization I interact with.
For example: out of the 3 contact people in the customer account that are listed ((VP Sales, Sales Manager, and Sales development rep) I have had an interaction (added the date of it in a field) with only 2 of them, based on that, the field should present 66.6%.
Of course that if I add a new contact to the customer account this should also be taken into consideration in terms of %.

Second: I would like to build a second formula that counts the number of interactions that were done with each contact in the organization in a date range perspective of 3 months. Meaning, I would like to assure that my team reaches out to each contact at least once every 3 months. How can I do that?

Thank you very much!

0 Replies 0