How Do I Get Symbols to Show?

Kristin Sullivan

I have formulas in place to display based on differences between two rows. I am migrating from SmartSheet Commercial to SmartsheetGov and I attempted to copy the formula displaying a green UP arrow using this formula =IF([Formula/Value1]27 >= [Formula/Value1]25, "Up", "Sideways") but field just displays the word "Sideways".

Paul Newcome

First make sure that you have selected the correct column type. Then click on the dropdown arrow in one of the cells in the column. It will show the symbol and text next to each other for the different options. The text is what you will need to use (case sensitive) in your formula.