mercredi 20 janvier 2016

Complex if statement on a SharePoint calculated column

I am trying to create a formula for a calculated column in SharePoint 2013 My columns are: W Certification, V Certification, Certification Sorting (This is the calculated column) If there are dates in both W Certification and V Certification, I want Certification Sorting to show a "3" If there is only a date in W Certification, Certification Sorting Should show a "1" If there is only a date in V Certification, Certification Sorting should show a "2"

Aucun commentaire:

Enregistrer un commentaire