# Use Markdown with a cell reference

**URL:** <https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965>\
**Category:** Ask for Help\
**Created:** [October 7, 2019, 11:25am UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965 "2019-10-07T11:25:41Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 11:25am UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/1 "2019-10-07T11:25:41Z")

</div>

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:

> ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/03154185f05f59c1c82681b4553e33fa76679f66.png)
> 
> (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

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 1:58pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/2 "2019-10-07T13:58:51Z")

</div>

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

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

```

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 2:26pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/3 "2019-10-07T14:26:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 2:28pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/4 "2019-10-07T14:28:02Z")

</div>

Post a sample spreadsheet.

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 4:49pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/5 "2019-10-07T16:49:24Z")

</div>

hi @George_B  
see link to sample file:

> [sample markdown contact - Google Sheets](https://docs.google.com/spreadsheets/d/1pJopmWAEO5aBZuZh0nnb0Du0upf-8fgvLmehVivQcc8/edit?usp=sharing)

let me know if you figure out a way to replace the **[mailto:info@configura.co.il](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!

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 4:53pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/6 "2019-10-07T16:53:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 5:08pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/7 "2019-10-07T17:08:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 5:11pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/8 "2019-10-07T17:11:35Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 5:11pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/9 "2019-10-07T17:11:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 5:14pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/10 "2019-10-07T17:14:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 5:15pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/11 "2019-10-07T17:15:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 5:18pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/12 "2019-10-07T17:18:56Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 5:20pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/13 "2019-10-07T17:20:47Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 5:26pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/14 "2019-10-07T17:26:53Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 7, 2019, 5:28pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/15 "2019-10-07T17:28:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 5:38pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/16 "2019-10-07T17:38:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 7, 2019, 6:39pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/17 "2019-10-07T18:39:30Z")

</div>

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](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>
"
```

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 7, 2019, 7:24pm UTC](https://community.glideapps.com/t/use-markdown-with-a-cell-reference/965/18 "2019-10-07T19:24:02Z")

</div>

> [@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