Combining a Symbol & Number

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;


Answers

  • Chris Mondeau
    Chris Mondeau ✭✭✭✭✭✭
    edited 02/17/20

    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!