Forum Discussion
Riz_K375
Jun 26, 2023Copper Contributor
Conditional field as per option selected
Hi team, I am not sure if this has been posted before or not. I had a look at the other posts but couldn't find the solution. I am trying to create a simple Change management tracking in Sharepoin...
tdprem
Jun 26, 2023Copper Contributor
- 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/
Riz_K375
Jun 27, 2023Copper Contributor
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?