Potential workaround for SFDC Formula Fields

[Malik_Zafar2]

Hello 

So we know that formula field updates in SFDC don't trigger the SystemModStamp, which means these fields won't update regularly and oftentimes require a manual sync.

Would the following solution work?

1) Field 1 is updated on Account object

2) Formula Field referencing Field 1 is updated with same value on lead object

3) Using a process builder, we take the value in the Formula Field and copy it to a static field

Would this work? Sounds like the static field should trigger a SystemModStamp

[SanfordWhiteman · Accepted solution]

Sure, that'll work fine. But I wouldn't do it with a dedicated field. Instead, have a datetime field that you can use for any such purpose. Update it to the current timestamp when you want to force a sync.

[Malik_Zafar2]

Ah, makes sense. Thanks Sandford!