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

Christina Salvucci 41 Reputation points
2022-09-01T22:01:26.347+00:00

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?

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
508 questions
{count} votes

Accepted answer
  1. Renjie Sun-MSFT 2,846 Reputation points Microsoft Employee
    2022-09-07T08:36:57.74+00:00

    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)  
    

    238513-image.png
    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.
    238470-image.png
    2.When 'Date1' column has value and 'check' column choose 'Yes': create item successfully.
    238477-image.png

    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.


2 additional answers

Sort by: Most helpful
  1. Renjie Sun-MSFT 2,846 Reputation points Microsoft Employee
    2022-09-02T07:57:40.107+00:00

    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:
      237241-image.png
      Failed:
      237089-image.png
    2. Both Date1 and Num2 has value:
      237168-image.png
      Success:
      237169-image.png

    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


  2. Christina Salvucci 41 Reputation points
    2022-09-06T15:40:33.057+00:00

    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!

    0 comments No comments