Reply To: Form filling 25-Oct training

Inner Circle › Ask Smartsheet Guru Crew Anything › Form filling 25-Oct training › Reply To: Form filling 25-Oct training

November 6, 2025 at 1:45 pm #678
Darren
Keymaster

    A few issues I see.
    1. there’s a substitute function without require parameters
    2. There’s a semi colon at the end of the URL with a weird numerical string, but maybe that’s a copy and paste issue?

    This should get you closer( assuming everything else matches your sheet). Also, I’m substituting out single spaces, but if you have any other special characters you’ll need to sub those out as well.

    =SUBSTITUTE(“https://app.smartsheet.com/b/form/d677350bdb444cce8eb920a9f155c3ab?SubmittalID=” + SubmittalID@row + “&Project ID=” + [Project ID]@row + “&Spec Section=” + [Spec Section]@row, ” “,”%20”)

    Here’s a reference for special characters: https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values#toc-include-special-characters-in-the-query-string