IF Statements
This is probably pretty basic but I just cant seem to get this formula right.
I am trying edit one cell base on another.
I want to update the Sales Stage based on the Probability. Here is the formulas that I created.
=iIF([Probability]="10%", "01 - Understand Customer", IF([Probability]="25%", "03 - Qualify Opportunity", IF([Probability]=50%, "04A - Develop Solution", IF([Probability] = "75%", "04B - Propose Solution", IF([Probability}="90%", "05 - Negotiate and Close", IF([Probability]="100%", "06 - Won, Deploy and Expand", "ERROR"
Thanks for help in advance
Answers
-
I did see the iIF in the first statement
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!