set column mandatory based on another column's value in datasheet view in sharepoint 2013

Question

Hi

I create a datasheet view in sharepoint list. Now I want to mandatory one column based on another column’s value in this view.

How I can do this?

Thanks.

Answer 1

Hi @ameneh maleki ,

You could set list validation to make a field mandatory based on a selection from another field in the sharepoint list. For example, when test2 field =1, test1 field is mandatory.

1.Go to List settings -> Validation settings -> Use following formula:

=IF([test2] = "1", IF(ISBLANK([test1]), false, true), true)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Xyza Xue

Thanks for your reply.

I didn’t have “Insert column” in Formula part in my sharepoint list setting page!

and when i use this formula, get me below error:

"The formula cannot refer to another column.  Check the formula for spelling mistakes or update the formula to reference only this column."

What’s the problem?!