# If Statement Help

Options
edited 12/09/19

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:

• ✭✭✭✭✭✭
Options

You are actually pretty close. You don't need to put Stage1 in parenthesis, and you need to use extra parenthesis on the end for each additional IF statement. I also suggest using @row instead of the actual row number.

Try this:

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

Keep going with that pattern, and you should have one ) at the end for every IF statement you use. In the example above there are 2 IF statements, so there are 2 ). If you have 6 IF statements, then you will have 6 ) at the end.

=IF(....., ......., IF(....., ....., IF(....., ....., IF(....., ....., IF(....., ....., IF(....., .....))))))

• Options

That did the trick.  Thank you so much!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!