Forum Discussion
Calculated Column w/ IF Statement HELP
Hello, I've been trying to create a calculated column to auto generate an input depending on other columns. When I enter my formula, I keep getting a syntax error and I can't seem to find the pr...
SXT3410 Try using this formula:
=IF([Product] = "Personal Care", "Personal Care",IF(AND([Testing?] = "Yes", [Test Type] = "Pre-Pro"), "Pre-Pro",IF(AND([Testing?] = "Yes", [Test Type] = "Post-Pro"), "Post-Pro",IF([Testing?] = "No", "Inside", ""))))
Make sure you are using correct display name of your columns in formula.
Note: Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.