Skip to main content
1 of 2
Radu
  • 11
  • 1

Sharepoint list validation formula issue

This is the first time asking here. I'm trying to write a formula for list validation but I cannot understand what I'm missing.

For this formula I need to chain 2 conditions

  1. [Start date]<= [End Date] (both columns are date columns)
  2. AND(ISBLANK([End Date]), [Status] = "Disabled)

Basically the [End Date] column value should be greater than [Start date] on one hand and on the other the [End date] column must not be empty while the [Status] column's value is "Disabled" ([Status] is a choice with 2 options column).

I came up with the following but apparently there's something wrong with the syntax

=IF(AND([Start Date]<=[End Date],IF(AND(ISBLANK([End Date]), [Status]="Disabled")FALSE,TRUE)FALSE,TRUE)

I've checked MS documentation and according to it the formula above should work:

https://support.microsoft.com/en-us/office/is-functions-586532cc-9888-4ca0-98b8-c874e4c8a087?ui=en-us&rs=en-us&ad=us https://support.microsoft.com/en-us/office/and-function-9ca21054-a466-477e-98bf-fc79e62afb3c https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a

Can you please help me figure this out?

I'm doing this in Sharepoint Online

Radu
  • 11
  • 1