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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Best (and only) solution