Forum Discussion
Conditional field as per option selected
- Go to list settings-> Validation Settings.
- Write in the formula to validate
=IF(Category="Medium",IF([Technical Review By]<>"",TRUE,FALSE),TRUE)
Kindly mark as answer after reviewing the answer.
-
Thanks,
Prem
https://www.linkedin.com/in/premtd/
tdprem why the formula is having error
=IF(Budget Shift Needed="Yes",IF([Budget Shift EURO]<>"",TRUE,FALSE),TRUE)
You have to wrap the column names in square brackets if there is space in the column display name, like [My Column Name]. Try using formula like:
=IF([Budget Shift Needed]="Yes",IF(ISBLANK([Budget Shift EURO]),FALSE,TRUE),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 above formula it does not work , The a Euro Value should not be required since I selected no
Hi tdprem ,
Thank you for your response. I just tested your solution and I am getting below error:
"Sorry, something went wrong
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas."
Is that because your Technical Review By is a text field and mine is Person?
