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 ...
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.
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.