SFDC Connector - Snapshot Then Track

I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My challenge is that I'm developing a project management process that relies on seeing the stages of those opps progress. The only way I've been able to make it work is to edit the workflow to show ALL stages of opportunities entered within the time frame. When I do that, I get 4,007 line items (which is seriously cutting it close to the limit in my opinion).

Conceptually speaking, what WOULD work is if I could somehow tell the connector to look at everything that's [OPEN] "right now", and then let me see the stages of progression of those opportunities (and new ones that will be created ongoing). Practically speaking, I'm not sure I can get that to work. As soon as I tell the connector to filter out non-open stages, it'll continue to run that logic, and the line items (as they progress) will filter out of sync.

Has anyone had this kind of challenge before? Any ideas? Please and thanks in advance!

Find more posts tagged with

Sales

Integrations

Project Management

Comments

Nathan Lloyd

Hi Charlie,

Unfortunately there's no available logic for "sync opportunities created right now through X stages then filter them out". The connector needs to be told explicitly what you want synced from the Salesforce instance. You could approach this a couple of ways in the connector:

Use the option you already noted of including all stages of progression within the workflow for a given time-frame desired
Create separate workflows for each stage and roll-up your opportunities with a Report so you can view the life for each in one place (this may help to avoid hitting the row limit)

On the Salesforce side of things, you could consider adding a field to flag opps that you want (or don't want) to see in Smartsheet. You could add a formula field that could be used to filter opps in (or out) instead of needing to define the stages and time-frame within the Salesforce Connector.

Hopefully that helps. Feel free to submit a case with Smartsheet Support if you would like us to take a closer look.

Kind regards,

Nathan L.

Sign in to join the conversation!

Quick Links

Trending discussions

DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
Onedrive & DocuSign Integration Capabilities
I am in the process of designing our Smartsheets workflow and am trying to better understand the capabilities / limitations of these integrations. Current Process: 1) We receive a PDF (say an invoice). 2)Manually save the file in Onedrive updating the file name. 3) Manually enter the data from the PDF into a SS Form and…