Making a column mandatory in SP List based on value in another column

%3CLINGO-SUB%20id%3D%22lingo-sub-1750820%22%20slang%3D%22en-US%22%3EMaking%20a%20column%20mandatory%20in%20SP%20List%20based%20on%20value%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750820%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20columns%20in%20my%20SP%20list%20in%20SharePoint%20Online.%3C%2FP%3E%3CP%3EFirst%20column%20is%20%22Status%22.%20Second%20column%20is%20%22Inactive%20Date%22%3C%2FP%3E%3CP%3ENow%2C%20if%20the%20status%20value%20equals%20%22Inactive%22%2C%20i%20would%20like%20the%20Inactive%20column%20to%20become%20mandatory%20so%20that%20the%20user%20enters%20the%20date%20when%20the%20report%20became%20inactive.%3C%2FP%3E%3CP%3EPlease%20suggest%20the%20easiest%20way%20for%20a%20SharePoint%20Admin%20to%20make%20it%20possible.%20I%20don't%20have%20much%20knowledge%20on%20SharePoint%20development%20at%20the%20moment-%20but%20can%20learn%20if%20the%20link%2F%20article%20details%20steps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1750820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Contributor

I have 2 columns in my SP list in SharePoint Online.

First column is "Status". Second column is "Inactive Date"

Now, if the status value equals "Inactive", i would like the Inactive column to become mandatory so that the user enters the date when the report became inactive.

Please suggest the easiest way for a SharePoint Admin to make it possible. I don't have much knowledge on SharePoint development at the moment- but can learn if the link/ article details steps.

0 Replies