Using decision symbols to change text

tim@gyroscope
tim@gyroscope ✭✭
edited 12/09/19 in Formulas and Functions

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.

Thanks.

Comments

  • 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
    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!