Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Creating Web forms with Auto-populated form content
I see that you can auto populate a section of the form by manually entering (post-URL):
where any spaces in the text are replaces with %20.
Question: I first used the substitute function to replace %20 for all spaces in a column that contains the desired text. But am unable to have the sheet pull that resultant text and combine it with the URL string. I get an "UNPARSABLE" message.
Is there any way to create a formula that can create the appropriate URL?