# Comma separator in if-else-if output

**URL:** <https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050>\
**Category:** Ask for Help\
**Created:** [February 22, 2024, 10:57am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050 "2024-02-22T10:57:17Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 22, 2024, 10:57am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/1 "2024-02-22T10:57:17Z")

</div>

Hey Guys,

I need to get an output out of if else if which is numerical input and output.

the Input reads 111,222,333

But output comes as 111222333

Is there a way to still hold the input with comma separator as the output of if-else-if?

Thank you guys!  
Regards,  
Dilip

---

<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:** [February 22, 2024, 11:10am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/2 "2024-02-22T11:10:16Z")

</div>

Depends what the if-then-else is referring to other than the input column, and how those columns are configured.

Please show screen shots of:

- the if-then-else column configuration
- all columns that it refers to

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 22, 2024, 11:16am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/3 "2024-02-22T11:16:27Z")

</div>

Hi Darren,

Please find the screenshot attached

 ![Screenshot 2024-02-22 at 4.45.04 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/0246a47065d60b2adf64d974f6dcabb19b3e4a42.jpeg)

Blue square portion represents the input with Comma separated values

The Red square portion represents the output

Regards,  
Dilip

---

<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:** [February 22, 2024, 11:19am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/4 "2024-02-22T11:19:14Z")

</div>

Okay. You would need to trace the source of each of those columns.

But… an easier option is to just add a Math column, point it at your if-then-else column, and re-apply the formatting.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 22, 2024, 11:22am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/5 "2024-02-22T11:22:08Z")

</div>

Thank you for the solution Darren, I did that actually , As it would need adding of another column I was wondering Would that be an ideal way or would there be any other way without having to add extra column?

Regards,  
Dilip

---

<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:** [February 22, 2024, 11:29am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/6 "2024-02-22T11:29:45Z")

</div>

I don’t know. I would need to look at every single column that feeds into that if-then-else column, and every single column that feeds into every single one of those, and so on, all the way back to the first non-computed column, and confirm that every column that is referenced in the whole chain is a number type. I don’t have the time or energy to lead you through that. But you’re quite welcome to have a go at it by yourself, it could be a good learning exercise.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 22, 2024, 11:32am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/7 "2024-02-22T11:32:27Z")

</div>

Thank you Jeff, Will check on this and feasibility and revert back.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [February 22, 2024, 11:48am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/8 "2024-02-22T11:48:00Z")

</div>

To me it seems that you are using a comma separator in your initial math columns and the single value columns are keeping this configuration.

The if-then-else else column is changing the format of the number and removing the comma separator.

As Darren suggested, you could add a math column after your if-then-else column for the single purpose of reformatting your numbers with the comma separator. Ideally, the if-then-else column would keep the original formatting or have a number-formatting option, but it doesn’t yet.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 22, 2024, 11:57am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/9 "2024-02-22T11:57:36Z")

</div>

Thank you Nathan for your reply.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 29, 2024, 11:58am UTC](https://community.glideapps.com/t/comma-separator-in-if-else-if-output/71050/10 "2024-02-29T11:58:15Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
