Forum Discussion

tracie3320's avatar
tracie3320
Copper Contributor
Oct 01, 2021

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 to be filled in else this cell cannot be filled in.

Thanks for assisting.

Formulas and Functions

2 Replies

  • DKoontz's avatar
    DKoontz
    Iron Contributor
    Oct 02, 2021

    tracie3320

     

    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.

     

    • tracie3320's avatar
      tracie3320
      Copper Contributor
      Oct 02, 2021
      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.

Resources