Importing Excel Formula into SmartSheet

dbarrack

I imported my URL builder in Excel with formulas so that my marketing team can all use it. The formula is "#UNPARSEABLE"

This is what I had in Excel:

=D3&"?RecType="&E3&"&utm_medium="&F3&"&utm_source="&G3&"&utm_campaign="&H3&"&utm_content="&I3

 

Can someone help? I did substtitue & with + but it isn't delivering my long-tail URL for tracking.

CanadaJim

This worked for me:

=[Primary Column]1 + "?RecType=" + [Column2]1 + "&utm_medium=" + [Column3]1 + "&utm_source=" + [Column4]1 + "&utm"

You'll have to be careful, though, to make sure that there are no spaces in the content of your cells.  If there are, it will break the URL.

Jim

 

dbarrack

@CanadaJim - Thanks!