[Hidden-tech] Google Sheets Question

[dlesser at ptraining.com]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20190626/d63fbaa7/attachment.html>