Convert Text into a Symbol

Hi All,

I am having great difficulty with what I think is a fairly straightforward formula (One of those days I think!). I have a basic Smartsheet containing two numbers. If one number is higher than the other or vice versa I want to bring in a Symbol pointing either up/down.

I know the text to show a symbol is up, down, sideways but I just can't seem to get the formula to work. I've trailed the forums but i'm still not getting it unfortunately. Any help is hugely appreciated. I have attached a screenshot with my work so far. If I can avoid having RAG Columns and just keep a simple formula that tracks with a single symbol in the far right column then that would be great.

For reference, we're simply trying to identify if transactions completed in a certain way are either up or down year on year.

Thank you!

Matt


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try something like this...

    =IF([2021 Conferma Transactions]@row > [2020 Conferma Transactions]@row, "Up", IF([2021 Conferma Transactions]@row = [2020 Conferma Transactions]@row, "Sideways", "Down"))


    You will need to change the "directions" to suit whichever symbol column type you have chosen.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!