How to do an IF, AND and Multiply scenario with multiple options
Options
Stacy Stoffel
✭✭✭✭✭
I am trying to do an IF, AND and Multiply scenario with multiple options. I still need to add the 3rd option, but wanted to figure out what I am doing wrong. I tested the first option, it worked. Adding the 2nd resulted in Unparsable.
Tags:
Answers
-
Hey @Stacy Stoffel
You have an extra parenthesis before the *2. Removing it should clear your Unparsable
Kelly
-
This works
But this does not work when I combine the two. I removed the parenthesis from before the *2, but the default is still Unparsable.
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!