Archive for February, 2013

Fahad Zia

SharePoint List Validation

Scenario: When the “Is Rebill” column(Yes/No) is Yes then “Rebill Amount” column cannot be empty. So this is the formula I wrote:

=IF([Is Rebill]="Yes",IF([Rebill Amount]="",FALSE,TRUE),TRUE) 

It did not work. The issue above is with Is Rebill=”Yes” which should be Is Rebill=True

Correct formula:

=IF([Is Rebill]=True,IF([Rebill Amount]="",FALSE,TRUE),TRUE)