[Hidden-tech] Google Sheets Question

Mon Jul 1 11:53:48 UTC 2019

Coming in late to the discussion…. I use Google sheets to manage work 
hours for a community garden.

NO ONE has the ability to change the actual worksheet that takes the 
data from the form and puts it into a worksheet, except me. They use the 
form to enter information. I have hidden this sheet so no one can see 
it, and have view only permissions for the two sheets where people can 
see their totals. I got a lot of help on the formulas from the Google 
Community.

If the owner is not tech-savvy, the person should delegate 
responsibility to manage the sheets to someone who is… Like the 
bookkeeper???

Dont’ know if my method will work for you.

Annamarie

On 26 Jun 2019, at 19:34, dlesser--- via Hidden-discuss wrote:

> Good thinking. I will definitely try that. Thanks.
>
> On 2019-06-26 11:30 am, Alex at Just Peachy wrote:
>
>> Could you dig through the document revision history [1] to see when 
>> the changes happened? You should be able to see what was changed and 
>> by who.
>>
>> Best,
>> Alex
>>
>> Alex Martines
>> Just Peachy Web Design
>>
>> On Wed, Jun 26, 2019 at 1:09 PM dlesser--- via Hidden-discuss 
>> <hidden-discuss at lists.hidden-tech.net> wrote:
>>
>> Thanks for the suggestions. Excel On-Line doesn't allow macros and 
>> has some other limits to functionality that might preclude its use. I 
>> will look into forms, though I will need to be able to load previous 
>> data as well as look at and enter this week's.
>>
>> Still looking to see whether anyone has run into Google Sheets quirks 
>> that can cause this behavior. I don't like to be blaming my clients 
>> unless I am clear that they are causing the problem. Usually, I can 
>> educate them, but this particular one is hard--if they are causing 
>> the problem, they are not aware of it and so it is hard to suggest 
>> modifications to their behavior.
>>
>> On 2019-06-26 9:28 am, Garth Shaneyfelt wrote:
>>
>> Provided they are familiar with Excel (and sharing and 
>> formulas...etc).  In my experience, people can mess those up pretty 
>> well too!
>>
>> -Garth Shaneyfelt
>> Let's Create a Better World
>>
>> On Wednesday, June 26, 2019, 11:18:01 AM EDT, Marla Michel via 
>> Hidden-discuss <hidden-discuss at lists.hidden-tech.net> wrote:
>>
>> Excel online on OneDrive (for any operating system) enables multiple 
>> people to share/access/update workbooks online and skip the 
>> unfamiliar Google Sheets quirks.
>>
>> Excel: https://office.live.com/start/Excel.aspx
>> OneDrive: https://onedrive.live.com/
>> Tutorial: https://www.excel-easy.com/examples/onedrive.html
>>
>> Marla
>>
>> On Wed, Jun 26, 2019 at 5:11 AM dlesser--- via Hidden-discuss 
>> <hidden-discuss at lists.hidden-tech.net> wrote:
>>
>> One last piece of info: she and most of her office are on Macs, if 
>> that makes a difference. I do not think she knows about keyboard 
>> shortcuts, but could be inadvertently using them.
>>
>> On 2019-06-26 6:05 am, dlesser at ptraining.com wrote:
>>
>> A question for the group.
>>
>> I have created a series of Google Sheets spreadsheets for a client. 
>> Her employees each fill out a timesheet, all of which are linked to a 
>> roll-up document that summarizes each week's payroll, etc. Each 
>> employee is linked to a separate sheet in the rollup sheet, which 
>> then uses some other sheets to summarize the payroll info. In my 
>> testing, these all work as designed all of the time.
>>
>> Over the past 3 months, I have had a number of issues where the 
>> formulas in the roll up sheets become disorganized. A link to F4 will 
>> turn into F187. I solved those problems by using Absolute values 
>> (e.g. $F$4) and they do not seem to have reoccured. i have protected 
>> some ranges, but since she is the owner, she can override the 
>> protection.
>>
>> This past week, two cells were overwritten by what looks like text 
>> from another part of the sheet (i.e., F4 and F15 were overwritten by 
>> text in F3 and F4). I do have a couple of scripts, but they simply 
>> copy the same named range each week and paste it as values on another 
>> sheet.
>>
>> My client si not very computer literate and is very awkward in using 
>> computers. I am attributing her problems to her inadvertent copy and 
>> pasting or moving cells since I cannot find any code or other way of 
>> making these changes except by a copy or move and paste or something 
>> similar.
>>
>> Does anyone else have these problems or any suggestions? I could do 
>> this in Excel with complete confidence that I can protect against any 
>> inadvertent changes, but Google Sheets is another beast entirely. We 
>> need to use Sheets because her office is distributed and everyone is 
>> on-line and not on a LAN.
>>
>> Any suggestions would be appreciated. 
>> _______________________________________________
>> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
>> Hidden-discuss at lists.hidden-tech.net
>>
>> You are receiving this because you are on the Hidden-Tech Discussion 
>> list.
>> If you would like to change your list preferences, Go to the Members
>> page on the Hidden Tech Web site.
>> http://www.hidden-tech.net/members
>
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion
> list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion
> list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
>
> Links:
> ------
> [1]
> https://support.google.com/docs/answer/190843?co=GENIE.Platform%3DDesktop&hl=en

> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion 
> list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20190701/8192b71b/attachment-0001.html>