I am trying to sync Sales cloud with Marketing Cloud. I have 3 parameters to check before I bring the data into marketing cloud. I decided to create a boolean formula field on the Sales cloud and use that as a criteria to sync the data across both the platforms. Is it possible? As I am reading everywhere that we can only use boolean fields to sync the MCConnect.

1 Answer 1


I already did exactly this for a client and it worked like a charm. So, yes.

However, be careful when syncing formula fields into marketing cloud. Formula field values only update in your synchronized data extension if an update to the record has happened since the last sync run. I ran into this issue myself...

The behaviour is documented here

  • is it better to set up the boolean field in Salesforce as a "Sync_to_MC" or "Do_Not_Sync_to_MC"? I'm trying to consider the pros and cons of both. Mar 20, 2020 at 15:34
  • @GregBeazley it doesn't really make a difference on the technical side. It's rather a matter what is easier to understand by your users and how it fits the pattern you govern data access and transfer. Mar 20, 2020 at 23:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .