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