• Multible Substitute in Googlegle sheet to make a prefilled link of goog

    From Pornpunsa Wuttisanwattana@21:1/5 to All on Sat Sep 10 20:02:44 2022
    Hi Everyone,

    I am trying to build a prefilled link of google form by using a substitute formula ,following the instruction in this link https://www.youtube.com/watch?v=vcEju__MPtw

    the problem is , once I start the seconde substituttion the text is replaced, the link doesn't work. ( It becomes a test message)

    Example
    =substitute(substitute($U$1,
    "Projectcode",A4),
    "Projectname",B4)

    A4 is replaced, and it is still a link, but when I add the 2nd substitute , it comes out as a text.

    Anyone please suggest Thank you !!!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)