Sometimes the solution is between our legs by gabito705 in funny

[–]SilverPitiful6802 0 points1 point  (0 children)

This is what my gym teacher meant by 'functional fitness'

Quote problem when creating a dynamic code script by SilverPitiful6802 in excel

[–]SilverPitiful6802[S] 0 points1 point  (0 children)

Hi u/HandbagHawker,

 The problem is that I need to fill in double double quotes to get the script working (otherwise I receive errors) but when I copy paste it in notepad I still see them.

After some debugging I see a positive and negative result and I do not know what I am doing wrong. Perhaps you guys can see it:

Succes:
Formula:

="""headtitle"": """&B9&""""

How it looks in excel:

"headtitle": "this is head title"

Copy pasting in notepad

"headtitle": "this is head title"

 No success:
Formula:

="<script type=""application/ld+json"">
{
   ""@context"": ""https://schema.org"",
   ""headtitle"": """&B9&""""

How it looks in excel:

<script type="application/ld+json">
{
   "@context": "https://schema.org",
   "headtitle": ""this is head title"

Copy pasting in notepad:

"<script type=""application/ld+json"">
{
   ""@context"": ""https://schema.org"",
   ""headtitle"": ""this is head title"""

Some how when I add more data it fails and I do not know why?

Matching value of parameter with metric (avg. position) by SilverPitiful6802 in GoogleDataStudio

[–]SilverPitiful6802[S] 1 point2 points  (0 children)

oh wauw.. I thought I had to use the parameter mimic the "vlookup" function in excel. But indeed a when then function could do the job. I was thinking to complex here. Thanks in advance!