With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, January 20, 2016
yogi_Restrict Entry 'Completed' Into Rows Of Column A Until Hours Have Been Entered In Column B Or D
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.