Smartsheet Salesforce Integration Question
I work in the Smartsheet/Salesforce connector frequently, but I am typically pulling information into Smartsheet from Salesforce.
The current issue I'm having is this: I have a Smartsheet that has a list of projects with columns of information about those projects. These projects are also Opportunities in Salesforce, right now, however, they are in no way connected to the Smartsheet list except that we know they are the same projects/they have the same name. I want to be able to a specific cell of information for each specific project to it's designated Salesforce opportunity.
I have pushed information from Smartsheet to Salesforce using the "Sync" checkbox, however, that was when it was a two way connector, so the projects were coming into Smartsheet from Salesforce, and then information was leaving Smartsheet to go to Salesforce.
Is there a way I can add a column to the smartsheet that specifies something about the Salesforce opportunity so that when i check the "Sync" box, the specific cell of information for that project goes to the correct opportunity in SF?