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
-
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!
Answers
-
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?
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!
-
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.
-
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!
-
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!
-
Happy to help. 👍️
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!