Combining a Symbol & Number

Lisanne Schliemann

Hello,

I have a column that calculates Q/Q growth and displays it as a percent. The next column shows that as a symbol based on an if statement.

For example, Q/Q growth is -61%, then the down arrow is displayed.

I'm building a dashboard, with a metric section and wanted to add display -61% + down arrow in the same row. Or have it that when you hovered over the down arrow it showed -61%.

Is there a way to do that or to combine the q/q growth % and symbol in the same cell;

Chris Mondeau

Hi Lisanne,

There's not a way to combine it in-cell within Smartsheet, but you could use a unicode emoji to substitute for something like this:

Here's the formula with the icons I used: =IF([%]@row < 0, [%]@row * 100 + "% 🔻", IF([%]@row > 0, [%]@row * 100 + "% 🔺", [%]@row * 100 + "% ➖"))

Here's a library of several icons you could choose from to make the colors mesh better: https://emojipedia.org/

Thanks!