Forum Discussion

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...

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

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