Salesforce Connector

Melissa Selzler

Good evening -

We use the Salesforce Connector to sync account information to Smartsheet. Syncing all accounts to a single Smartsheet exceeded cell limits. So, we created a different Smartsheet for each account status (i.e. Client, Former Client, Vendor, etc.). I hoped to create an automation that would remove the un-synced rows, but it appears that is not possible and I must manually remove rows that fall under "Filtered out by sync." Please confirm if this is accurate.

Also, I want to be able to summarize the number of each account status, but I do not want to include those "Filtered out by sync." Is there a way to exclude these in a formula so I can publish counts, and only manually delete the un-synced rows periodically (i.e. weekly or monthly)?

Thank you,

Melissa