# Google sheet Formula and Formatting

**URL:** <https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035>\
**Category:** Ask for Help\
**Created:** [March 28, 2020, 7:11pm UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035 "2020-03-28T19:11:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![batescr](https://avatars.discourse-cdn.com/v4/letter/b/49beb7/32.png) [@batescr](https://community.glideapps.com/u/batescr)\
**Post date:** [March 28, 2020, 7:11pm UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035/1 "2020-03-28T19:11:35Z")

</div>

Is there anyway to carrier the formatting from Google sheets to the app?

Here is example of the data in Google sheets

![googlesheets formatting](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b0fbcde922ebeadd3c146b88613c79cb414d554f.png)

When the app it shows up like this? (i have tried plan text and rich text box)

 ![appformatting](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/555db674765ae0d4fe306b0896a991f2bba51a15.png)

thanks

---

<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:** [March 29, 2020, 6:07pm UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035/2 "2020-03-29T18:07:30Z")

</div>

As far as font or color, no. It’s just data so that type of stuff will not come across, however I think Glide is pretty good at getting the column type (text, date, number, etc, boolean, etc), but that’s about it. The only way to get the red color at this time would be to use rich text and unsupported html tags around the value. Probably some combination of template columns and If-Then columns to determine if the value is above or below zero.

---

<div class="post-metadata">

**Author:** ![batescr](https://avatars.discourse-cdn.com/v4/letter/b/49beb7/32.png) [@batescr](https://community.glideapps.com/u/batescr)\
**Post date:** [March 29, 2020, 9:14pm UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035/3 "2020-03-29T21:14:11Z")

</div>

Do you have any examples?

---

<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:** [April 2, 2020, 1:41am UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035/4 "2020-04-02T01:41:49Z")

</div>

There are several posts and a quick google search shows how to do html. Again, Glide advises against using html in a rich text component since it can stop working at any time. Just be prepared if html stops being recognized in the app. I’m sure some day Glide will give us the option to adjust coloring, but for now this is the only option. There are limited options with markdown in the rich text component as well as the new Text component

> [@Salon Beauty/ Barber Shop app💈](https://community.glideapps.com/t/salon-beauty-barber-shop-app/4314):
>
> Hey hey, Gliders! First topic here! I’ve been using and abusing glide all over my days for months. And to open this topic, I wanna introduce you my new brand Salon Beauty/ Barber Shop app! barber What will you see here? Circle Profile Image using Rich Text (not tiles); Screens and Font Color totally personalized by the theme and for each person. And much more. Let’s take a look. I made two apps for Salon Beauty/ Barber Shop app! barber: Admin Clients Adminiphone point_right [htt…](https://sallonadmintemplate.glideapp.io)

> [@Google Sheet does not match data view in Glide](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/20):
>
> The logo is just an image with a lot of empty space on the left. It functions as a button to take the user to an “About” screen. “CHALLENGE PERIOD” is just a Glide Basic Text component. I fiddled around to determine the color and size of the header font (color: #666666; font-weight: 400; font-size: 0.857em;) so I could mimic it in the table. The table itself was a lot of trial and error in Markdown. Here’s the formula in the cell: ="\<span style='color: #666666; font-weight: 400; font-size:…

> [@Simple idea of showing a customer message](https://community.glideapps.com/t/simple-idea-of-showing-a-customer-message/891):
>
> I had a simple idea of displaying a message to the customer, I used the HTML code to display the message, it can be typed directly into the cell or the way I did using the new column template options. \<html\>\<h1\>\<marquee\>\<font color="#F5D0A9"\>Horário de atendimento das 08:00AM as 06:00PM\</font\>\</marquee\>\<h1\>\</html\> Sample Application: [https://2oxda.glideapp.io](https://2oxda.glideapp.io)

---

<div class="post-metadata">

**Author:** ![defektim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/defektim/32/9846_2.png) [@defektim](https://community.glideapps.com/u/defektim)\
**Post date:** [June 28, 2020, 1:45pm UTC](https://community.glideapps.com/t/google-sheet-formula-and-formatting/6035/5 "2020-06-28T13:45:52Z")

</div>

Think of it a bit differently.  
Think of it as information that prompts the user to action.  
If someone did not pay or still owes money, you want to help them pay.  
So instead of showing the text in red (and you can use the GLIDE fields MATH and IF-THEN-ELSE columns instead of your formulas), show a button.  
You can even set the text on that button with a GLIDE ‘TEMPLATE’ column (that you show if the ‘still owe’ column is less than 0) and reads “You still owe . Click to pay”