SalesForce connector to Smartsheet Filter records Does Not allow 'OR' only 'AND'?

dsmartsheetuser

SalesForce connector only allows for Filtering Operator 'AND' and Not 'OR', why is this case and what is a workaround for a scenario. 

Type ID: Not Equal to 'ABC' 

OR 

Type ID: Not Equal to 'XYZ'

?

Alejandra

Hello,

You could use the "includes one or more" option to select one or more possible values within that field.

 

Pam Parrish

I need the connector to filter when rows don't contain a certain record. Is there any way to do this?