sharepointformulacalculated-columnssharepoint-2016

SharePoint Excel Calculated formula for Column


I have calculated field in my SharePoint 2016 on premises list, which checks for four 4 columns and update the calculated column based on the result, I have used this formula but its showing syntax error.

=IF(Column 4=ISBLANK,IF(Column 3=ISBLANK,IF(Column 2 =ISBLANK,IF(Column 1=ISBLANK,E2,Column 1),Column 2 ),Column 3),Column 4)

Solution

  • Use ISBLANK(Field)

    =IF(ISBLANK([Column 4]),IF(ISBLANK([Column 3]),IF(ISBLANK([Column 2]),IF(ISBLANK([Column 1]),"E2",[Column 1]),[Column 2]),[Column 3]),[Column 4])