If Statement Help

ggross
ggross ✭✭
edited 12/09/19 in Formulas and Functions

I have a column with 6 options and I am trying to create a statement in another column that says: 

=IF((Stage1) = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9c-51b4-40fb-bf06-73174c348733")

I have 6 total stages but can't seem to get this to work.  Any advice?

Geneva

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!