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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!