Forum Discussion

SXT3410's avatar
SXT3410
Copper Contributor
Oct 07, 2022

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 problem. Any help would be greatly appreciated! 

 

Product (Choice)Testing? (Choice)Test Type (Choice)Cal Type (Calculated)

Personal Care

YesPre-ProPersonal Care
Home FrgNoPost-ProPre-Pro
   Post-Pro
   Inside

 

Here is the formula I've tried... can someone take a look to see what the error may be?

 

=IF([Product] = "Personal Care", "Personal Care",

    IF(AND([Test?] = "Yes", [Test Type] = "Pre-Pro"), "Pre-Pro",       

       IF(AND([Testing?] = "Yes", [Test Type] = "Post-Pro"), "Post-Pro",

          IF([Testing?] = "No", "Inside"))))

 

Thank you!

 

SharePoint Online

1 Reply

Sort By
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Oct 08, 2022

    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.

Resources