Forum Discussion
Solved
Calculated Column - Blank Values Nested IF Statement
Hello,
I could use some assistance with a formula for my calculated column within a SharePoint List.
example:
| column1 | column2 | output | |
| row1 | Yes | ||
| row2 | 12 | No | |
| row3 | Yes | ||
| row4 | 14 | No | |
| row5 | 15 | 15 | No |
| row6 | Yes |
I would like the [output] to be the calculated column.
if [column1] and [column2] is blank, I would like [output] to "Yes", and if either [column1] or [column2] is blank I would like [output] to "No"
I am currently running into the error:
"Sorry, something went wrong
The formula contains a syntax error or is not supported."
Just using this IF statement works
The formula contains a syntax error or is not supported."
Just using this IF statement works
=IF(column1="","Yes","No")
but if I'd like to add on another or nest it throws that error. could someone please assist?
Thanks,
Marcirose
mrciroseg Try using this formula:
=IF(AND(ISBLANK([column1]),ISBLANK([column2])),"Yes","No")If you are still getting the same error try this:
- Use correct display names of columns
- Use semicolon (;) instead of comma(,) in formula
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.
3 Replies
mrciroseg If column1 and column2 are of type Number, you can also try this:
=IF(COUNT([column1],[column2])=0,"Yes","No")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.
mrciroseg Try using this formula:
=IF(AND(ISBLANK([column1]),ISBLANK([column2])),"Yes","No")If you are still getting the same error try this:
- Use correct display names of columns
- Use semicolon (;) instead of comma(,) in formula
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.
- ganeshsanap thanks so much it worked! Did not even have to substitute for semicolon
