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
Solved! Go to Solution.
Ah, makes sense. Thanks Sandford!