I'm looking to create a calculated column in a SharePoint list.
If column1,column2,column3,column4 and column5 all have dates Show as complete, If not Incomplete.
Thanks.
Add a comment
|
2 Answers
Try this formula:
=IF(AND(NOT(ISBLANK([Column1])), NOT(ISBLANK([Column2])), NOT(ISBLANK([Column3])), NOT(ISBLANK([Column4])), NOT(ISBLANK([Column5]))), "Complete", "Incomplete")
Try using formula for your SharePoint calculated column like below:
=IF(OR(ISBLANK([Column 1]),ISBLANK([Column 2]),ISBLANK([Column 3]),ISBLANK([Column 4]),ISBLANK([Column 5])),"In Complete","Complete")
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(,). - Use correct display name of your SharePoint columns in above formula.
- Wrap column names inside
[]if your column name has space in it. For example:[My Column Name].