yogi_Restrict Entry 'Completed' Into Rows Of Column A Until Hours Have Been Entered In Column B Or D

Google Spreadsheet   Post  #2026

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2016

post by: Tom:

https://productforums.google.com/forum/#!topic/docs/p2pqQ_KEJzU;context-place=forum/docs
Possible to restrict adding value if adjacent cell is empty?
Hi Again!

I'm at risk of running out of goodwill here after asking so many questions but this might be an interesting challenge to some of you geniuses!

In the sample sheet here - is there anyway to prevent setting the status to "Completed" until the hours cell next to it has been completed? The practical purpose for me is to remind (make) staff enter their hours working on a task prior to marking a job as complete.

Thanks as always :)

----------------------------------------------------------------------------------------------------------------------------------