# Convert Text into a Symbol

Options
✭✭✭

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

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

Are you having an issue with getting an error with your formula, or do you have a formula with no error and it is not outputting the actual symbol?

• ✭✭✭
Options

Hi Paul,

To be honest, i've tried a few ways but I can't get any of them to work.

This is the start of what I believe is correct '=IF([Red] = "Red" "Down",' but I need to loop this to also say if Amber show 'Sideways' and if Green show 'Up".

I'm not sure this is even the best way. Is there a way I can get Smartsheet to recognize if the number under the '2021' Column is higher, show an up arrow, same show a sideways arrow and if lower, show a down arrow?

We essentially want to see an upward trend in the 2021 Column across all individual staff and across departments.

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭
Options

Paul, that's worked a treat. I was just not understanding the second part and how to get it to show more than one symbol. You've saved me so much time. Thank you!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!