Share via

SharePoint List validation between two columns

Anonymous
2020-09-15T22:12:02+00:00

on the surface, this seems so simple.  but i can't for the life of me figure this out.

2 columns.  if there's data in both columns, i want it to FAIL.  it's OK if they're both empty.  they can put data in one column, but not the other also.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-09-16T02:15:23+00:00

    Hi BSquared61,

    You may add the following formula to the list validation:

    =OR(ISBLANK([Column1]),ISBLANK([Column2]))

    After adding this list validation, if there are values in both columns, it will prompt list validation failed. And if only one of the columns has a value or the values of both columns are empty, the validation passes.

    Best regards,

    Madoc

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-09-17T08:08:17+00:00

    Hi BSquared61,

    Have you checked the above reply? Feel free to post back if you need further assistance.

    Best regards,

    Madoc

    0 comments