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.
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

Well I got it to work with the formula below, which is essentially your formula, but retyped! 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.

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 405 Global Discussions
 215 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!