02/08/13
Fahad Zia
tags:  

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) 

Leave a Reply

*