IF statement (Compare column with String)

Hi all,

i want to compare the Content of a Column with a text but i always get an error message because of a Syntax error.

It the Content of the column Approval Status is Approved the System should write in the calculated column the String "Approved"

my code:

=IF([ApprovalStatus]="Approved","Approved"," ")

can you help me ? what is wrong here?

thank you in advance

April 17th, 2015 10:44am

Hi

yes, because  you should numeric values

Approval Status

Value

Approved

0

Rejected

1

Pending

2

Draft

3

Schedule

4

https://farhanfaiz.wordpress.com/2010/12/17/sharepoint-approval-status-value-of-publishing-pages/

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics