Problem with if/and/or statement
Hello, I am trying to build an if/and/or statement that does the following: If record owner = "this role" and checkbox A is "true", then show this generate template button or If record owner =...
Forum Discussion
One big thing to keep in mind while writing formulas is to consider the 'type' of fields you are using.
For example:
Record Owner is a User field and needs to be evaluated to a user.
Checkboxes are =true or =false, not ="true" or ="false"
URL fields us the url or Null, not "null"
Text fields use the "Text" or null with two quotes ""
Your formula currently has a lot of mix matched types, thus the errors.
What are the field types of all the fields AND values you are comparing? Then we can get the syntax correct.
For example:
Record Owner is a User field and needs to be evaluated to a user.
Checkboxes are =true or =false, not ="true" or ="false"
URL fields us the url or Null, not "null"
Text fields use the "Text" or null with two quotes ""
Your formula currently has a lot of mix matched types, thus the errors.
What are the field types of all the fields AND values you are comparing? Then we can get the syntax correct.