Sharepoint List column validation

[Tamil681]

Hi,

I have a sharepoint list like below. When Column1(Y/N) or Column2(Y/N) is empty then in Status(Value1/Value2) choice column when users are trying to select value 2 it should block the action and throw an error as fill the mandatory fields likewise.

I have already marked "Require this column contains info" option for Column1(Y/N) and Column2(Y/N).

but when i fill the validation setting it is throwing error as cannot reference other columns

Column1(Y/N)	Column2(Y/N)	Status(Value1/Value2)

[#2]

Hi Tamil681,

Unable to understand the problem statement, could you please share more in detail.

[#3]

In my Sharepoint list i have 3 columns and these columns are of datatype choices. I want to restrict the user to change column 3 when Column1 or Column2 are empty.

[#4]

Hi @Tamil681,

I believe there is no OOTB solution available for your problem. We can add conditional column but it will not work with your custom status choice column. 

You can use Microsoft Power App to set such conditions easily with Low Code - No Code.