Oct 01 2021 04:25 PM
Is it possible to make a cell required based on the value in another cell? Here's what I am trying to do.
Thanks for assisting.
Oct 01 2021 05:01 PM - edited Oct 01 2021 05:02 PM
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.
Oct 01 2021 05:14 PM