# Formula Question (Text Multiplier)

**URL:** <https://community.fibery.io/t/formula-question-text-multiplier/3003>\
**Category:** Get Help\
**Created:** [June 26, 2022, 3:59pm UTC](https://community.fibery.io/t/formula-question-text-multiplier/3003 "2022-06-26T15:59:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ccollins](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@ccollins](https://community.fibery.io/u/ccollins)\
**Post date:** [June 26, 2022, 3:59pm UTC](https://community.fibery.io/t/formula-question-text-multiplier/3003/1 "2022-06-26T15:59:16Z")

</div>

I couldn’t find any other threads about this. Thank you to any advice in advance.

**Text Multiplier**

- Are there any functions that would let me multiple text? My specific use case would be having emojis represent a count or length function. Currently I’m just running if loops with a max.
- One example is aligning the list view. Subtracting the length of the previous column with dot emojis to align the next column. Another example is to build progress bars dependent that show the number of tasks completed out of a total.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [June 26, 2022, 4:54pm UTC](https://community.fibery.io/t/formula-question-text-multiplier/3003/2 "2022-06-26T16:54:07Z")

</div>

> [@ccollins](#):
>
> - having emojis represent a count or length function.
> - build progress bars dependent that show the number of tasks completed out of a total.

Have you considered using a report view to generate such visual representations?

> [@ccollins](#):
>
> Subtracting the length of the previous column with dot emojis to align the next column

There are plans to update/combine the table view and list view so that the benefits of both can be combined. When this is done, column alignment shouldn’t be a problem I imagine. Unfortunately, release date is still unknown.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [June 27, 2022, 4:50am UTC](https://community.fibery.io/t/formula-question-text-multiplier/3003/3 "2022-06-27T04:50:06Z")

</div>

There is a more compact way of generating the string than nested If’s, though it won’t address alignment issues in a List view.

You could add padding characters so the output is always the same length, like:

```auto
Left("⭐⭐⭐⭐⭐", <length>) + Left(" ______", 5 - <length>) 

```

It might work to use a non-breaking space for the filler char – `Alt+0160` on Windows (numeric keypad).