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)