Forum Discussion

Joe Fischer's avatar
Joe Fischer
Brass Contributor
Jun 27, 2018

Validation Setting in SPO list IF / OR Functions

Hi All, I have an SPO custom list where If [Renewal Frequency] is either "N/A" or "As Needed" I would like [Renewal Date] to be required.  I know how to do this for one or the other, but I can't g...
App
developer
Lists
SharePoint Online
Sites
Anonymous's avatar
Anonymous
Jun 27, 2018

well actually looking at this you need to basically nest the OR in with an AND, so you need to re-evaluate with =AND(OR([Renewal Frequency]="N/A",[Renewal Frequency]="As Needed"),IF([Renewal Date]="",TRUE,FALSE),TRUE)

Something similar, can't test syntax, but it should get you on right path.

 

Reference: https://support.office.com/en-us/article/and-function-78956048-53c7-484a-ab0b-6e70d7f03400?ui=en-US&rs=en-US&ad=US

 

  • Joe Fischer's avatar
    Joe Fischer
    Brass Contributor
    Jun 28, 2018

    Thanks Christopher,

    I can't belive how difficult it is to get the AND/OR cobination to work.  So far no go :(

     

    I can enter an item with N/A or As Needed without a date, but every time I try to add a date or or other choices it errors.

    Still working on this, has to be a combination of all and I may have to play with "=" or "<>" and flip around the TRUE/FALSE

     

    Thanks again,

    Joe

Resources