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!


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!