0

I am trying make the Billing Status field required only when the A La Carte field is checked (true) or not blank (otherwise it is not required). I don't know whether to set this up in infopath or on the Sharepoint list or if it is possible?

How do I get this formula to work in List Validation settings?

IF([A La Carte]"Yes",(AND(NOT(ISBLANK([Billing Status])),TRUE)
  • What all are your conditions? – Ganesh Sanap Mar 16 at 0:22
  • 1
    Also there is syntax error in your formula: [A La Carte]="Yes" – Ganesh Sanap Mar 16 at 0:25
  • I'm trying make the Billing Status field required only when the A La Carte field is checked (true) or not blank (otherwise it is not required). I don't know whether to set this up in infopath or on the Sharepoint list or if it is possible? – vier111 Mar 18 at 15:52
  • When I put this in the List Validation settings nothing happened. – vier111 Mar 19 at 21:21
1

I don't know all your requirements. But I guess you want "Billing Status" field to be mandatory if "A La Carte" is equal to "Yes"(Correct me if I am wrong).

In this case you need to use below formula:

IF([A La Carte]="Yes",NOT(ISBLANK([Billing Status])),TRUE)
  • Have you tried this yet? Let me know if you need anything else. – Ganesh Sanap Mar 17 at 4:36
  • I'm trying make the Billing Status field required only when the A La Carte field is checked (true) or not blank (otherwise it is not required). I don't know whether to set this up in infopath or on the Sharepoint list or if it is possible? – vier111 Mar 18 at 15:36
0

Probably need a better description of your requirements. But here's a guess:

=AND( [A La Carte] = "Yes", NOT( ISBLANK( [BillingStatus] ) ) )

If "A La Carte" is a Yes/No column then use this:

=AND( [A La Carte], NOT( ISBLANK( [BillingStatus] ) ) )

This indicates:

A La Carte = Yes    BillingStatus has any value     item is valid
A La Carte = No     BillingStatus has any value     item is NOT valid
A La Carte = Yes    BillingStatus is blank          item is NOT valid
A La Carte = No     BillingStatus is blank          item is NOT valid

Note that an IF statement is not needed as validation formulas only need to return True or False, and AND does that.

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.