Use Markdown with a cell reference

[yinon_raviv]

hi all,

any of you knows how to combine markdown with a cell reference?
for example, if i want to include an image of email that clicking on it will open a draft mail i"ll use:

(mailto:info@configura.co.il)

now, i want instead of the mail address to refer to a cell in my sheet. that way, i can change the address without reviewing all my markdown

thanks in advance!
Yinon

[George_B]

You just have to build the markdown by using a lot of:

= "markdown text" & C2 & "more markdown" & A2 & "even more markdown" & D2

[yinon_raviv]

Hi @George_B
Tried this before but the problem is that I’m trying to connect this to icon and mailto function and don’t seem to manage to make this work

[George_B]

Post a sample spreadsheet.

[yinon_raviv]

hi @George_B
see link to sample file:

sample markdown contact - Google Sheets

let me know if you figure out a way to replace the mailto:info@configura.co.il in cell A2 with reference to cell C2 and the tel:+972547007027 in A2 with the reference number in cell B2

appreciate the help!

[George_B]

I just made the change, how does what I did work?

[yinon_raviv]

@George_B
works perfectly!!! you are the MAN
don’t understand why it didn’t work for me

[George_B]

Sometimes you just need a fresh set of eyes as they say. Great ideas BTW, I love how you guys come up with these things and share them.

[yinon_raviv]

i’ve added in cell D2 the full code for you to see. with the full code your soultion isn’t working

when i’m trying to add the = sign with " like you did in the example I get error massage

[George_B]

What do you mean by the full code. Where did you copy and paste that from?

[yinon_raviv]

I did this in the app I shared earlier (https://yinon-raviv.glideapp.io)

[George_B]

Yeah I saw the app. But I still don’t understand. In the app are you saying that you have only one Component and it’s Rich Text? If that is the case I would suggest breaking it up into a few columns and multiple Rich Text components.

[yinon_raviv]

I know I can do that but it looks less nice and create spaces between the components while if it’s all in one I can control the spaces between the lines to make this nicer.
Did you see the full code in one cell?

[George_B]

I do see it but I don’t see any of the cell references like I did in Cell A2. Plus it does not start with a =". You have to build the markdown as I did starting with=“markdown here” & B2 & “markdown here” & C2 etc.

[George_B]

FYI, going offline for a meeting. I’ll look later at what you have done.

[yinon_raviv]

thanks, when you do look, you’ll see i’ve added the reference and got the error. maybe you could understand what i’m doing wrong

[Jeff_Hager]

I think the portion at the end is messed up. I think what’s happening here is you are trying to get a string with a quote character (") in the final result, but a quote will break of a string. It’s kind of hard to explain but you need to escape the quote character by using a double quote. Hopefully this makes more sense. https://webapps.stackexchange.com/questions/58017/how-do-i-output-a-string-containing-quotation-marks I’ve include the fixed portion below. No guarantees that I did it correctly, but at least the error goes away.:

<div style=""text-align: right""> קונפיגורה מספקת שירותי ייעוץ וליווי עסקי ליזמים, עסקים קטנים ובינוניים וסטארטאפים.
אנחנו מלווים את לקוחותינו לאורך כל שלבי העסק, מהרעיון, דרך בניית תוכנית עסקית וכלה בבניית מערכות מורכבות מבוססות אקסל  וגוגל שיטס כדוגמת מערכות תפעול, ניהול מלאי, כספים, דשבורדים, מחירונים ועוד.

יחידה נוספת מתמחה בהדרכות של קורסים לארגונים ואינדיבידואלים של אופיס מבית מיקרוסופט וגוגל עם התמקדות ודגש על אקסל וגוגל שיטס </div>
"

[yinon_raviv]

@Jeff_Hager

hi Jeff,

I completely understand your point but unfortunately it didn’t work. what i did is remove the right alignment and replace it with center (which dosn’t use “”) and that solved the problem.

thank you both @George_B and @Jeff_Hager