Using If/Then Formula
I'm new to Smartsheet and have a drop down menu that needs to tie to another column/field I am trying to create a if/then formula but obviously I'm doing something wrong as I keep getting an #UNPARSEABLE error. I'm trying to say "if Industry Examinations equals Series 24, then add the description, and if not, then leave blank. Help?! Thank you!
=if([Industry Examinations]=Series 24,"150 multiple choice questions; 3 hours and 30 minutes testing time. This examination qualifies individuals required to register as general securities principals in order to manage or supervise the member's investment banking or securities business for corporate securities, direct participation programs, and investment company products/variable contracts.","")
Help Article Resources
Check out the Formula Handbook template!