How to make a column required based on another column's info?

Question

I'm trying to make a column required based on another column having a value. I've seen plenty of examples where you can make a column required based on another column's value, but all those examples include "Choice" data.

My example is if "Inactive Date" is filled in and has ANY value in it (whether it be a date from 20 years ago or today), I want to make the column "Inactive Reason" to become a required field.

I feel confident this is possible, but I just can't seem to figure it out. Can anyone provide a suggestion?

Answer 1

Dear @Christina Salvucci ,

Thank you for the reply.

SharePoint does not support using column validation for the multiple lines of text.
Here is a workaround for reference, hope that could help you a little.

=IF(LEN(Date1>0),check=TRUE)  

I create a Yes/No column named 'check' and set this column default value is ‘No’. When column 'Date1' has value, 'Yes/No' column need choose 'Yes' manually. It could remind you to fill your multiple column in this list. If you do not choose the Yes/No column to 'Yes', an error message 'Multiple line of text have not been filled in' will be displayed.

1.When 'Date1' column has value and 'check' column do not choose 'Yes': Error message is displayed.

2.When 'Date1' column has value and 'check' column choose 'Yes': create item successfully.

But your multiple line of text column still can be blank. This only reminds you to fill out that column.

Yours sincerely,
Renjie Sun

---

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

Dear @Christina Salvucci ,

Thank you for your post in our forum.

Per my test, you could add a list validation with the following formula:

=IF(LEN(Date1>0),LEN(Num2)>0,LEN(Num2)=0)  

In my testing, when Date1 is not null, Num2 must require information.

Here is my testing result:

1. When Date1 has value and Num2 is null:
   
   Failed:
   
2. Both Date1 and Num2 has value:
   
   Success:
   

Should you have any questions or concerns, please do feel free to contact me.

Yours sincerely,
Renjie Sun

---

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 3

Thank you for the reply. Unfortunately (I didn't realize this before trying the formula) since the field I have that I want to make required/conditional is a multiple lines option I can't select it from the options for the formula. I will think of something else

Thank you!