Using decision symbols to change text

Please can somebody help me, I'm new to formulas!

I'm trying to get text in a cell to change depending on what decision symbol has bee selected (YES, NO, HOLD)

I managed to get it working with just 'YES' as follows:

=IF(Graphic6 = "YES", "Includes GRAPHICS see schedule")

but I also want different text "No GRAPHICS" to appear if the 'NO' is selected. I have a feeling I need an OR statement, but i can't get it to work. Suggestions would be much appreciated.



  • Hi Tim,

    Try use this formula:

    =IF([your column name]1 = "yes"; "yes statement"; IF([your column name]1 = "hold"; "hold statement"; "no")) and please let me know if it works for you.


  • Thank you Marcin. Unfortunately that comes out as #UNPARSEABLE

  • tim@gyroscope
    edited 09/28/18

    Well I got it to work with the formula below, which is essentially your formula, but re-typed! Must have been a tiny difference I'm missing, any how it works now:

    =IF(Graphic6 = "yes", "yes statement", IF(Graphic6 = "no", "no statement"))

    Thanks for your help.

  • Marcin P
    Marcin P
    edited 10/01/18

    Glad to hear that!

    Depend on users location and probably keyboard settings, there is a difference between separation marks in formulas. You use comma in formulas and I ahve to use semicolon. Also I see that your formula has no square brackets, while mine has :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!