Forum Discussion
SharePoint Column Validation
Note: You have to add this formula in List validation settings and not column validation settings.
Follow below steps:
- Go to SharePoint list
- Click on Settings icon and select List settings
- Select Validation settings
- Add formula & user message and click Save
Reference: List validation if then syntax
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
SXT3410 This is possible using List validation settings. You can use formula like:
=IF([Column 1] = "Yes", OR([Column 2] = "Pre", [Column 2] = "Post"), TRUE)
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap I tried this code, but I got an error when I tried
=IF(RequiresPreparation="Yes",OR(TaskType="Pre",TaskType="Post"),FALSE)It ran perfect