Making a cell required

%3CLINGO-SUB%20id%3D%22lingo-sub-2804538%22%20slang%3D%22en-US%22%3EMaking%20a%20cell%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2804538%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20make%20a%20cell%20required%20based%20on%20the%20value%20in%20another%20cell%3F%26nbsp%3B%20Here's%20what%20I%20am%20trying%20to%20do.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EWhen%20%3CSTRONG%3EK10%3C%2FSTRONG%3E%20(Status)%20equals%20Complete%2C%20%3CSTRONG%3EM10%3C%2FSTRONG%3E%20(Actual%20End%20Date)%20%3CSTRONG%3EAND%20O10%3C%2FSTRONG%3E%20(Hours)%20is%20required%20to%20be%20filled%20in%20else%20this%20cell%20cannot%20be%20filled%20in.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThanks%20for%20assisting.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2804538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Is it possible to make a cell required based on the value in another cell?  Here's what I am trying to do. 

 

  • When K10 (Status) equals Complete, M10 (Actual End Date) AND O10 (Hours) is required to be filled in else this cell cannot be filled in.

Thanks for assisting.

2 Replies

@tracie3320

 

Would this work? If end date and hours are populated, it will turn K to "complete".

 

=+IF(AND(M10<>"",O10<>""),"Complete","")

 

DKoontz_1-1633132838900.png

 

If you need more strict requirements, look into adding data validation, you can completely restrict what is entered into a cell.

 

Thank you. Unfortunately, this would not work. We are already auto populating the status field. We are wondering if there is a way to make a field required when that status is auto set to Complete.