Forum Discussion
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 get OR to work using :
=IF([Renewal Frequency]<>"N/A",IF([Renewal Date]<>"",TRUE,FALSE),TRUE)
I tried to add the OR condition below, but no go :(
=IF(OR([Renewal Frequency]="N/A",[Renewal Frequency]="As Needed"),IF([Renewal Date]="",TRUE,FALSE),TRUE)
Can anyone please tell me what I am doing wrong?
Thanks,
Joe
3 Replies
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
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
