I am trying ti create a calculated column where it will add the vale "has been completed" if the approval column is approved. Below are the code and screenshot of the error.

Thank you

    =IF([Approval Status]="Approved","has been completed")

enter image description here


You do not have a FALSE clause as third IF parameter but that is no error, should default to FALSE.

Most likely you need the ; (semi-colon) as separator and not a , (comma)

| improve this answer | |
  • Thanks, Danny, But when I put semicolon says 'you have a syntax error in the formula'. – Narinder Chauhan Nov 16 '16 at 12:34
  • So add the False output – Danny '365CSI' Engelman Nov 18 '16 at 10:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.