Link to home
Start Free TrialLog in
Avatar of Stacey Payne
Stacey Payne

asked on

Sharepoint 2016 Column Validation Nesting (IF, ISBLANK, AND)

I have two IF Statements I need help nesting. I continue to get an error message when trying to nest these. Any help would be great!

IF( (ISBLANK([Task])), "TASK", "False" )

IF( (ISBLANK([Access No.])) AND (ISBLANK([Application ID])), "Access App", "False")

Basically if [Task] is blank and if [Access No.]&[Application ID] is blank, I need an indicator. If not I need an indicator. I hope this makes sense. Thank you!
ASKER CERTIFIED SOLUTION
Avatar of Michiel Hamers
Michiel Hamers
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Best (and only) solution