I have 4 custom objects I'm using that are all set to private - Project Location, Project, Field Items & Materials.

I have multiple Roles that need access to all these records depending on if they are in the associated country.

The country is set on the Project Location record.

Initially, I set up formulas on the 3 other custom objects to pull in the relevant Country so I could then create Custom Sharing rules on the 3 custom objects so they're shared with the correct Role (segmented by Country).

Sharing Rules cannot use Formulas as a criteria point.

I've now attempted to create a WFR on the Project object to set a custom field with the country to fire whenever the Country on the Project Location changes.

I'm getting this issue: Error: Function ISCHANGED may not be used in this type of formula

Has anyone done found a workaround, or accomplished something simular?

  • 2
    Could you edit your question to show us the workflow you've created? – David Reed Jul 5 '19 at 11:22
  • It would also be useful to see the schema you're working with. Is Project Location the Parent of the other three objects? If so, is it possible to create a master-detail relationship? If you have a master-detail relationship, the child objects will inherit the sharing rules of the parent object. – TheDevAdmin Jul 5 '19 at 18:02

The reason why this error is coming because the evaluation criteria selected is :

created, and any time it's edited to subsequently meet criteria

enter image description here

Choose the evaluation criteria as

created, and every time it's edited

and then you should be able to use ISCHANGED enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.