Sharepoint 2013 List validation - two fields contain text

Question

Pardon this newbie question on SharePoint list validation, I have been researching this for days

SharePoint 2013
SharePoint LIST validation since you cannot compare two fields in FIELD validation
Two fields in same list:

field#1 -- Employee's Email Address

field#2 -- Vendor Contact Name

Validation - If both fields contain data then don't allow the form to save. Basically if either field is blank allow the form to save.

I know this works for one field at a time: =ISBLANK([Employee's Email Address])=TRUE Sales 19 =COUNTA([Column1], [Column2]) Counts the number of nonblank columns (2) Sales 19 =COUNTA([Column1], [Column2], [Column3]) Counts the number of nonblank columns (2) — dwinters, Jun 12, 2020 at 17:41

Ganesh Sanap - MVP · Accepted Answer · 2020-06-12 18:27:40Z

0

Try Using below formula :

=IF(OR(ISBLANK([Column1]), ISBLANK([Column2])), true, false)

answered Jun 12, 2020 at 18:27

45k21 gold badges30 silver badges61 bronze badges

Add a comment |

1 Answer 1