# Need 3 Icons in STATUS ICON for CovidSOS

**URL:** <https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898>\
**Category:** Ask for Help\
**Created:** [April 22, 2021, 3:49am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898 "2021-04-22T03:49:20Z")\
**Posts on this page:** 19\
**Page:** 2

<div class="post-metadata">

**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\
**Post date:** [April 22, 2021, 5:55am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/22 "2021-04-22T05:55:38Z")

</div>

sorry I didn’t get your question…

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 22, 2021, 5:57am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/23 "2021-04-22T05:57:36Z")

</div>

where do you change (click) status?  
i see column STATUS, but i cant find where do you click on it

---

<div class="post-metadata">

**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\
**Post date:** [April 22, 2021, 6:00am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/24 "2021-04-22T06:00:23Z")

</div>

in the patients section  
with “is this resolved”

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 22, 2021, 6:04am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/25 "2021-04-22T06:04:51Z")

</div>

and you changing status column by clicking choices picked/resolved ?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 22, 2021, 6:11am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/26 "2021-04-22T06:11:04Z")

</div>

ok… got it…

Change column status from boolean to text  
create 3 columns in isuess sheet with single value of each color  
than change if column

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 22, 2021, 6:23am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/27 "2021-04-22T06:23:24Z")

</div>

ok?

 ![Capture 115](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0e5f80a869a7819bcff8d8f86103ec655b18c50e.png)

---

<div class="post-metadata">

**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\
**Post date:** [April 22, 2021, 6:49am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/28 "2021-04-22T06:49:41Z")

</div>

Just checking uzo

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 22, 2021, 7:17am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/29 "2021-04-22T07:17:29Z")

</div>

did you get how i changed columns?

---

<div class="post-metadata">

**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\
**Post date:** [April 22, 2021, 8:07am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/30 "2021-04-22T08:07:10Z")

</div>

Hey, that was not it But we resolved it by using two booleans and putting if else on status icon!

Thank you so much Uzo! Your replies really helped us with that!

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 22, 2021, 8:13am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/31 "2021-04-22T08:13:18Z")

</div>

You can use only one boolean by checking if not empty, and changing column type from boolean to text

 ![Capture1112](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/8838cfcf6e1613660395a1c9af1200334a6c7bdd.png)

---

<div class="post-metadata">

**Author:** ![Chirag\_Mediratta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chirag_mediratta/32/2758_2.png) [@Chirag\_Mediratta](https://community.glideapps.com/u/Chirag_Mediratta)\
**Post date:** [April 23, 2021, 1:14am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/32 "2021-04-23T01:14:47Z")

</div>

Yes, I did that!

---

<div class="post-metadata">

**Author:** ![Tiny\_Bricks](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tiny_bricks/32/64998_2.png) [@Tiny\_Bricks](https://community.glideapps.com/u/Tiny_Bricks)\
**Post date:** [October 8, 2023, 8:05am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/33 "2023-10-08T08:05:26Z")

</div>

hey what can i do for the case where i need 4-5 options

eg  
i need something for if its been  
0-45 days (green circle shown)  
46-75 days (orange circle shown)  
76-89days (red circle shown)  
90+ days (black circle shown)  
and if possible  
if blank (grey circle shown)

hope yo can assist

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 8, 2023, 8:59am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/34 "2023-10-08T08:59:10Z")

</div>

Configure an if-then-else column as follows:

- If X is greater or equal to 90 , then black
- If X is greater or equal to 76, then red
- If X is greater or equal to 46, then orange
- If X is greater or equal to 0, then green
- Else grey

 ![CleanShot 2023-10-08 at 16.58.29@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8d9d83e98e1e438fc95ea881c8cd9dae12b34a4d.png)

---

<div class="post-metadata">

**Author:** ![Tiny\_Bricks](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tiny_bricks/32/64998_2.png) [@Tiny\_Bricks](https://community.glideapps.com/u/Tiny_Bricks)\
**Post date:** [October 8, 2023, 9:37am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/35 "2023-10-08T09:37:25Z")

</div>

thank you soo much

but 1 more question  
how do i add the coloured dots? what option do i choose to use the dots??

 ![Untitled](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b93f365c988de45fbdc2de5038ac2018ae9e6a9.png)  
have temp used text to show the colour but not sure how to go about the dots.

sorry only new to this

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 8, 2023, 9:39am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/36 "2023-10-08T09:39:36Z")

</div>

They are emojis, you can paste them in.

Depending on how the column is being used, you could also use an Image from Colour column to generate an image from the text.

---

<div class="post-metadata">

**Author:** ![Tiny\_Bricks](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tiny_bricks/32/64998_2.png) [@Tiny\_Bricks](https://community.glideapps.com/u/Tiny_Bricks)\
**Post date:** [October 8, 2023, 10:41am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/37 "2023-10-08T10:41:43Z")

</div>

Any further help on this ?

Not sure what to do cant work out how to even paste anything in etc

![image0.jpeg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dfef1ac9f331afa550fc218838041269e328e684.jpeg)

---

<div class="post-metadata">

**Author:** ![Tiny\_Bricks](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tiny_bricks/32/64998_2.png) [@Tiny\_Bricks](https://community.glideapps.com/u/Tiny_Bricks)\
**Post date:** [October 8, 2023, 10:48am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/38 "2023-10-08T10:48:42Z")

</div>

I already have an image in table for something else so can’t find emojis or option to paste anything

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 8, 2023, 11:27am UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/39 "2023-10-08T11:27:31Z")

</div>

[https://emojipedia.org/search?q=circle](https://emojipedia.org/search?q=circle)

Please find what you need here.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e3da181dcbdc81f35a7691c9b814825320c6263.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 8, 2023, 1:58pm UTC](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898/40 "2023-10-08T13:58:37Z")

</div>

> [@Tiny\_Bricks](#):
>
> I already have an image in table for something else so can’t find emojis or option to paste anything

Did you figure it out?

Just as a side note, I’m curious about your “Days Ago” column…

 ![CleanShot 2023-10-08 at 21.54.31@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/deed5a90c59d6ff3b7eb358cf565f74275362936.png)

I can see that it’s configured as a Number type, which suggests that either the values are manually entered, or perhaps they are calculated using a Spreadsheet formula?

Anyway, just in case you are not aware, it would be possible to automatically calculate that for all rows using a Glide Math column with the formula `Trunc(Now-Date)`, where `Now` is the Current Date/Time, and `Date` is your “Date Last Worked” column (assuming that’s what used to calculate it).

[Previous page](https://community.glideapps.com/t/need-3-icons-in-status-icon-for-covidsos/25898.md?page=1)
