[Hidden-tech] Google Sheets Question

[Joseph Steig]

you can do range and sheet protection in Google sheets easily.

On Wed, Jun 26, 2019 at 9:20 AM Garth Shaneyfelt via Hidden-discuss <
hidden-discuss at lists.hidden-tech.net> 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/ee59cd39/attachment.html>