Allow date in cell but only when all other cells complete

Lincoln Brown

Good morning,

This question may have been asked many times, so apologies if so, but is there a way to stop a user entering a date into a cell until all the other cells in that row have been completed and filled in.

This would then stop the row being moved to another sheet partially complete, because that cell is the trigger for the automation.

Many thanks

Andrée Starå

Hi @Lincoln Brown

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• You could add a message that shows until the other cells are filled in
• You could add a condition to the move row workflow so it doesn't move until all cells are filled in

Would any of those options work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

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

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

Lincoln Brown

Where would this message go? Would it be automated on all rows.