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.
ganeshsanap hello can you also help me, the column is budget needed? Yes/No, if user select yes the they need to input the budget amount in the column Value.
I tried this formula but I’m having error
=IF(Budget Needed="Yes",IF([Value]<>"",TRUE,FALSE),TRUE)
Melow28 Is your "Budget Needed" of column type "Choice" or "Yes/No" (Boolean)?
Try using formula like:
=IF([Budget Needed]="Yes",IF(ISBLANK([Value]),FALSE,TRUE),TRUE)
Make sure to use the correct display names of your list columns in formula. Also, check above responses/Notes for more understanding.
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 thanks for the tip, I tried it but I'm having error. What I would like to have is if someone selected Budget Shift is needed "Yes" , then they will be required to input in the Euro Value column the amount , but if they select "No" in column Budget Shift is needed, then they will not be required to input amount in the Euro Value column
You have to make your "Euro Value" column non-mandatory as mentioned here: Conditional field as per option selected
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.