I need two custom fields created that would check the following:
1. Lookup how many other opportunities there are for a data point on the opportunity, and return the count. For example, if the state on the opportunity was FL, this new field would check how many other opportunities there are open with the state of FL. If there were 16, then on every opportunity that has a state of FL, there would be a custom field with the value of 16.
2. Similar to 1 above, except this would count the number of contacts (activities) on the single opportunity and return the value. So, if for example, opportunity ABC has 18 contacts, then this new field would show a value of 18 on the ABC opportunity.