Formula for Symbols



hope this is easy enough but im still trying to master my formulas with symbols. Can anyone help me with this one? I need to use the symbol to indicate if current month is more, less or same as prior month @row

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would use a nested IF statement.

    =IF([AR Days Current Month]@row>[AR Days Prior Month]@row, "up arrow", IF([AR Days Current Month]@row<[AR Days Prior Month]@row, "down arrow", "right arrow"))

    You will need to replace each "directional arrow" with the appropriate text value. You can find out what text values to use by clicking on one of the cells in the symbol column and expanding the options as if you are going to manually select them.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!