Allow data entry only if another column is not empty

Charter YPI

Hi everyone,

To help you understand, our business is about rentals. In our sheet, we have columns for:

1. Date the contract was issued
2. Date "from" (when the rental starts)
3. Date "to" (when it ends)

I am trying to find a way to allow Data entry in columns 2 & 3 only if there is a date in column 1.

If column 1 is empty, employee should not be able to fill in column 2 & 3.

I have read about dependencies but it seems to only be helpful for cell automations which is not really my goal here as "date from" and "date to" are random.

Would you have any advice on how I could achieve the above?

Many thanks for your help

Laureen

Andrée Starå

Hi @Charter YPI

You can either add conditional formatting/message that shows that it shouldn't add data before the first column is filled.

Another option is to add it through a form and use conditional logic, and set the other fields as required.

Make sense?

Would any of those options work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Charter YPI

Hi Andree,

Thank you for your quick reply!

I have tried conditional formatting + adding a description but mistakes keep coming up.

Can a form be used to complete information in a row instead of creating a new row?

Thank you! :)

Andrée Starå

@Charter YPI

You're more than welcome!

Could you use an Update Request instead?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!