Salesforce connector - rows not meeting filter are not being filtered out

In Smartsheet I have a sheet with an integration to Salesforce. I have configured the integration to only pull in rows that meet a certain criteria.

To test the integration, I ran the integration to pull in data. I them went to Salesforce to edit one record of the data that was integrated to no longer match the filter conditions.

The only way I can get this record filtered out of the Smartsheet is to manually run the workflow. If I just wait the connector will update other records if new data has been entered, but the row that no longer meets the filter remains in place?

Find more posts tagged with

Accepted answers

All comments

jessica.smith

@ESzczesuil

I don't believe that the Salesforce Connector can remove items from the connected sheet, only add and sync. On my connected sheet, when a record no longer meets filter conditions, it's nested under a row called "Filtered out by Connector - not synced" (screenshot below).

If I wanted to remove the rows that no longer meet the filter criteria automatically, I would probably set up this workaround.

Set up a column with a column formula that allows you to distinguish between rows that are still being synced to Salesforce and those that are not. I'd use this formula =COUNT(ANCESTORS()) which will count the number of ancestors each row has. Only the records that don't meet filter criteria should equal 1 once they are nested under the "Filtered Out" row.
I'd set up an automation on the sheet to MOVE the rows that no longer meet the filter criteria to a helper sheet. The trigger would be, when rows are changed and "Ancestors" changes to 1.

Do you think something like this might work for your use case?

ESzczesuil

@jessica.smith Thank you for your reply. What you have described is probably a more detailed explanation of what I meant by 'filtered out'. I understand Smartsheet will not remove the data, and instead will move the row under the parent row "Filtered out by Connector - not synced", but my issue is - I can only get this to occur when I manually force the intregration to run. Otherwise the row that should be moved as a child to the above noted parent row remains in place.

If I am in Salesforce and update a record (keeping the record within the integration filter) I see the updates reflect in Smartsheet immediately. But when I edit a record in Smartsheet to no longer meet my filter criteria for the integration, this is when nothing occurs.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.