0

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)
Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
MHI
  • 37
  • 4

1 Answers1

0

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])
Lee
  • 5,305
  • 1
  • 6
  • 12