Convert Text into a Symbol

Matt Wood

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

Paul Newcome

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.

Paul Newcome

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?

Matt Wood

https://community.smartsheet.com/discussion/comment/311953#Comment_311953

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.

Paul Newcome

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.

Matt Wood

https://community.smartsheet.com/discussion/comment/311990#Comment_311990

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!

Paul Newcome

Happy to help. 👍️