Making a cell required

Copper 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.