Forum Discussion
Making a cell required
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 t...
Would this work? If end date and hours are populated, it will turn K to "complete".
=+IF(AND(M10<>"",O10<>""),"Complete","")
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.