Marketing Cloud Connect Formula Field Changes

Marketing Cloud Connect Formula Field Changes

To improve synchronization between Sales, Service Cloud, and Engagement, you can no longer use a formula field as an object filter in Synchronized Data Sources. You can still use formula fields to filter data on your synchronized objects. You can’t select a formula field type when using the Boolean filter for new objects or updating existing objects. You can use a Boolean filter on all other field types.

If the boolean formula fields are used, the fields are still available for filtering in the user interface until Spring ’23. Any existing filter will continue to work as long as you don’t need to edit the sync configuration. If you experience sync issues with the filters using formula fields, you will need to update the filter and remove the formula from the filter. Performing any edits to the sync configuration after the Spring ’23 release removes the formula field filter automatically.

In the Spring ’23 release, the previously synced configuration option is removed. The prior formula field will no longer display as a dropdown value in the filter.

This change became effective with the Winter ’23 release for new filters. Also, it was first announced in the Summer ’22 release notes and documented in this article. Support for existing filters is available until the Spring ’23 release.

Creating objects that use formula fields as a filter is no longer supported. Update your existing filter configurations to avoid issues with formula fields before the Spring ’23 release.

If you have concerns about how this will impact your Salesforce Synchronized Data Sources, contact your Summit team.

Ready to Chat?

Get a jumpstart by connecting with one of Summit's Salesforce Certified Experts today.

"Easy to Work With"
Angie W.

Northwoods worked with Summit to help migrate our Microsoft Dynamics CRM system to Salesforce.  Mike and his team were extremely knowledgeable, thorough, and easy to work with.  They were able to help us configure the system to handle complex business processes while making the system easy for end users.  They were also able to migrate all our legacy Dynamics data to the new Salesforce system.  Summit helped train our technical team on Salesforce administration while keeping the project on time and under budget.  I highly recommend Summit for any Salesforce-related project.

"Mind Blowing!"
Rachael H.

As a leader of a small non-profit aimed to scale rapidly and efficiently, I knew it was critical to transition from antiquated spreadsheets to a sophisticated CRM. We dabbled in Salesforce on our own the year prior. To put it mildly, I was terrified to go there again. Mike and his team at Summit met my apprehension with confidence and reassurance. They were timely, efficient and positioned us to utilize Salesforce in ways we hadn’t imagined. Every day I’m in awe of what Salesforce can do; to Mike’s credit for imparting his wisdom. Summit has positioned us for unprecedented opportunities at Walk with a Doc. Thank you!

"BEST Salesforce Consultant Available"
Catherine Z.

We went through 3 consultants before finding Summit. The difference was night and day, and the cost was very reasonable. They helped us get our Communities up and running in less than a week (after 2 other teams essentially dragged their feet for 9 months - yes, 9 months!). We are ecstatic! We also have Managed Services with them, for a few hundred bucks a month they are our go-to for anything Salesforce. The team is INSTANTLY responsive - like within 2 minutes. I have experienced other consultants and can tell you, there is no comparison. Hire Summit!

"Did a Wonderful Job"
Paige B.

We have primarily been using Salesforce for our sales team. Recently we decided to bring our support team on and Summit did an awesome job helping us get everything set up the way we needed.

"Great Learning and Implementation"
Annette H.

Great experience with Summit. They are very knowledgeable about Salesforce and their turn around is outstanding. I am looking forward to working Part 2 of our plan with them.

"Transformation Data w/ Excellent Service"
Kay W.

The skill set and knowledge that Mike Leibrand has brought to this project far surpasses our initial expectation- especially since our initial contact with Salesforce corp. was challenged in regards to utilizing training videos to suit our scope and need. Mike has been helpful in supporting our team with a custom solution in order for us to be able to serve our community better. He is timely and professional, and eager to learn about the why before telling us the what.

"Made our Dream CRM a Reality!"
Matt S.

Mike and his team at Summit Tech made our Salesforce dream a reality. As a small non-profit on a limited budget with very specific CRM needs we were challenged to find a suitable Salesforce partner. Fortunately we were introduced to Summit Tech, and from day one they made the formidable task of implementing Salesforce doable (and even enjoyable!). Mike is a pro, from his accessibility and communication to industry knowledge and attitude, he never said 'no' to a request. When we encountered hiccups along the way he took the time to trouble shoot and make fixes, even when it was outside the original scope of the project. We didn't deviate from the project timeline or budget, which says a lot considering our custom needs for data collection/reporting, donor communication, and third party plug-ins. If you are considering implementing Salesforce or have any Salesforce needs, I highly recommend Mike and his team.

Name(Required)