Smartsheet - Salesforce Connector

Context:

In Smartsheet, I have a project intake sheet with many columns of data related to each project. I have set up a workflow in the Smartsheet-Salesforce connector that routinely syncs over relevant data from Smartsheet to Salesforce opportunities and vice-versa.

Problem:

I am having trouble syncing over the column that has the project folder hyperlink from Smartsheet to the relevant Salesforce field. The Salesforce field is the URL field type. Is there some constraint wherein we are not able to push URL data from Smartsheet to Salesforce?

Additional Info:

See attached image of hypothetical project. The 'Project Folder Link' column is a hyperlink and syncs over to the appropriate Salesforce field but only pushes text; not the actual URL.

2019-07-24 15_56_14-Benefits Intake Sheet - SFDC - 2019 - Smartsheet.jpg

Find more posts tagged with

Healthcare

Integrations

IT & Operations

Comments

Alejandra

Hello,

Thank you for working with our Support team on this! Our Support team mentioned that the Project Folder Link is automatically populated in the intake sheet which means that how the cell contents are created (such as URL instead of hyperlink) isn't currently editable.

They suggested creating a new column in the intake sheet and manually adding the Project Folder URLs to this column instead. This would avoid changing any sheets, reports or dashboards that use the Project Folder Link field but still allow the URL to be targeted by the Salesforce Data Connector.

Sign in to join the conversation!

Quick Links

Trending discussions

DataMesh: What if the lookup value column is a formula?
I have a sheet to track travel, which includes a Start Location column and End Location column, and a third "Start - End" column which contains a formula that combines the first two columns. I've done this so that I can reference another sheet, which has the estimated cost from Location A to B, using DataMesh. However,…
Dynamic View edit button missing
The edit button is missing from the right side of the dynamic view that I am the owner of. This is a recent development as I have edited this dynamic view previously. Typically the edit button is on the right side of the dynamic view screen. Why would the edit button be missing? How can this be corrected?
Dynamic View - New Item Submission
Under USM and setting up dynamic view for users to edit, comment, etc. without a license - can users also submit a new item through the New Item Submission control turned on without a license?