[Hidden-tech] Google Sheets Question

[Alex at Just Peachy]

Could you dig through the document revision history
<https://support.google.com/docs/answer/190843?co=GENIE.Platform%3DDesktop&hl=en>
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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20190626/d7c83202/attachment-0001.html>