<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/xhtml; charset=utf-8">
<style>
div.plaintext { white-space: normal; }
body { font-family: sans-serif; }
div.plaintext h1 { font-size: 1.4em; }
div.plaintext h2 { font-size: 1.2em; }
div.plaintext h3 { font-size: 1.1em; }
blockquote.embedded,div.plaintext blockquote { margin: 0 0 5px; padding-left: 5px; border-left: 2px solid #777777; color: #777777; }
blockquote.embedded blockquote.embedded,div.plaintext blockquote blockquote { border-left-color: #999999; color: #999999; }
blockquote.embedded blockquote.embedded blockquote.embedded,div.plaintext blockquote blockquote blockquote { border-left-color: #BBBBBB; color: #BBBBBB; }
div.plaintext a { color: #3983C4; }
blockquote.embedded,div.plaintext blockquote a { color: #777777; }
blockquote.embedded blockquote.embedded,div.plaintext blockquote blockquote a { color: #999999; }
blockquote.embedded blockquote.embedded blockquote.embedded,div.plaintext blockquote blockquote blockquote a { color: #BBBBBB; }
div.plaintext math[display="inline"] > mrow { padding:5px; }
div.plaintext div.footnotes li p { margin: 0.2em 0; }
</style>
</head>
<body>
<div class="plaintext"><p dir="auto">Coming in late to the discussion…. I use Google sheets to manage work hours for a community garden. </p>
<p dir="auto">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.</p>
<p dir="auto">If the owner is not tech-savvy, the person should delegate responsibility to manage the sheets to someone who is… Like the bookkeeper??? </p>
<p dir="auto">Dont’ know if my method will work for you. </p>
<p dir="auto">Annamarie</p>
<p dir="auto">On 26 Jun 2019, at 19:34, dlesser--- via Hidden-discuss wrote:</p>
</div>
<blockquote class="embedded"><div style='font-size: 12pt; font-family: Verdana,Geneva,sans-serif'>
<p>Good thinking. I will definitely try that. Thanks.</p>
<div> </div>
<p><br /></p>
<p>On 2019-06-26 11:30 am, Alex at Just Peachy wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div dir="ltr">
<div dir="ltr">Could you dig through the document <a href="https://support.google.com/docs/answer/190843?co=GENIE.Platform%3DDesktop&hl=en" target="_blank" rel="noopener noreferrer">revision history</a> to see when the changes happened? You should be able to see what was changed and by who.</div>
<div dir="ltr"> </div>
<div>Best,</div>
<div>Alex</div>
<div> </div>
<div> </div>
<div>Alex Martines</div>
<div>Just Peachy Web Design</div>
<br />
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">On Wed, Jun 26, 2019 at 1:09 PM dlesser--- via Hidden-discuss <<a href="mailto:hidden-discuss@lists.hidden-tech.net">hidden-discuss@lists.hidden-tech.net</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;">
<div style="font-size: 12pt; font-family: Verdana,Geneva,sans-serif;">
<p>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.</p>
<p>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.</p>
<div> </div>
<p><br /></p>
<p>On 2019-06-26 9:28 am, Garth Shaneyfelt wrote:</p>
<blockquote style="padding: 0px 0.4em; border-left: 2px solid #1010ff; margin: 0px;">
<div class="gmail-m_-7723591193435645656ydp29a93097yahoo-style-wrap" style="font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 16px;">
<div>
<div>Provided they are familiar with Excel (and sharing and formulas...etc). In my experience, people can mess those up pretty well too!</div>
<div> </div>
<div class="gmail-m_-7723591193435645656ydp29a93097signature">
<div style="font-family: Helvetica,Arial,sans-serif; font-size: 16px;">-Garth Shaneyfelt<br />
<div>Let's Create a Better World</div>
</div>
</div>
</div>
<div> </div>
<div> </div>
</div>
<div id="gmail-m_-7723591193435645656ydp50eb4aceyahoo_quoted_1686572179" class="gmail-m_-7723591193435645656ydp50eb4aceyahoo_quoted">
<div style="font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 13px; color: #26282a;">
<div>On Wednesday, June 26, 2019, 11:18:01 AM EDT, Marla Michel via Hidden-discuss <<a href="mailto:hidden-discuss@lists.hidden-tech.net">hidden-discuss@lists.hidden-tech.net</a>> wrote:</div>
<div> </div>
<div> </div>
<div>
<div id="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Excel online on OneDrive (for any operating system) enables multiple people to share/access/update workbooks online and skip the unfamiliar Google Sheets quirks.</div>
<div> </div>
<div>Excel: <a href="https://office.live.com/start/Excel.aspx" target="_blank" rel="noopener noreferrer" shape="rect">https://office.live.com/start/Excel.aspx</a></div>
<div>OneDrive: <a href="https://onedrive.live.com/" target="_blank" rel="noopener noreferrer" shape="rect">https://onedrive.live.com/</a></div>
<div>Tutorial: <a href="https://www.excel-easy.com/examples/onedrive.html" target="_blank" rel="noopener noreferrer" shape="rect">https://www.excel-easy.com/examples/onedrive.html</a></div>
<div> </div>
<div>Marla</div>
<div> </div>
</div>
</div>
</div>
</div>
<br clear="none" />
<div class="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053gmail_quote">
<div id="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053yqt96440" class="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053yqt4154757275">
<div class="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053gmail_attr" dir="ltr">On Wed, Jun 26, 2019 at 5:11 AM dlesser--- via Hidden-discuss <<a href="mailto:hidden-discuss@lists.hidden-tech.net" shape="rect">hidden-discuss@lists.hidden-tech.net</a>> wrote:</div>
<blockquote class="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left: 1px solid #cccccc;">
<div style="font-family: Verdana,Geneva,sans-serif; font-size: 12pt;">
<p>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.</p>
<div> </div>
<p><br /></p>
<p>On 2019-06-26 6:05 am, <a href="mailto:dlesser@ptraining.com" shape="rect">dlesser@ptraining.com</a> wrote:</p>
<blockquote style="margin: 0px; padding: 0px 0.4em; border-left: 2px solid #1010ff;">
<p>A question for the group.</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>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.</p>
<p>Any suggestions would be appreciated.</p>
</blockquote>
</div>
_______________________________________________<br clear="none" /> Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net" target="_blank" rel="noopener noreferrer" shape="rect">http://www.hidden-tech.net</a><br clear="none" /><a href="mailto:Hidden-discuss@lists.hidden-tech.net" shape="rect">Hidden-discuss@lists.hidden-tech.net</a><br clear="none" /><br clear="none" /> You are receiving this because you are on the Hidden-Tech Discussion list.<br clear="none" /> If you would like to change your list preferences, Go to the Members<br clear="none" /> page on the Hidden Tech Web site.<br clear="none" /><a href="http://www.hidden-tech.net/members" target="_blank" rel="noopener noreferrer" shape="rect">http://www.hidden-tech.net/members</a></blockquote>
</div>
</div>
</div>
</div>
<div id="gmail-m_-7723591193435645656ydp50eb4aceyqt51534" class="gmail-m_-7723591193435645656ydp50eb4aceyqt4154757275">_______________________________________________<br clear="none" />Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net" target="_blank" rel="noopener noreferrer" shape="rect">http://www.hidden-tech.net</a><br clear="none" /><a href="mailto:Hidden-discuss@lists.hidden-tech.net" shape="rect">Hidden-discuss@lists.hidden-tech.net</a><br clear="none" /><br clear="none" />You are receiving this because you are on the Hidden-Tech Discussion list.<br clear="none" />If you would like to change your list preferences, Go to the Members<br clear="none" />page on the Hidden Tech Web site.<br clear="none" /><a href="http://www.hidden-tech.net/members" target="_blank" rel="noopener noreferrer" shape="rect">http://www.hidden-tech.net/members</a></div>
</div>
</div>
</div>
</blockquote>
</div>
_______________________________________________<br /> Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net" target="_blank" rel="noopener noreferrer">http://www.hidden-tech.net</a><br /><a href="mailto:Hidden-discuss@lists.hidden-tech.net">Hidden-discuss@lists.hidden-tech.net</a><br /><br /> You are receiving this because you are on the Hidden-Tech Discussion list.<br /> If you would like to change your list preferences, Go to the Members<br /> page on the Hidden Tech Web site.<br /><a href="http://www.hidden-tech.net/members" target="_blank" rel="noopener noreferrer">http://www.hidden-tech.net/members</a></blockquote>
</div>
</div>
</blockquote>
</div></blockquote>
<div class="plaintext"><blockquote>
</blockquote><blockquote><p dir="auto">_______________________________________________<br>
Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net">http://www.hidden-tech.net</a><br>
Hidden-discuss@lists.hidden-tech.net<br>
<br>
You are receiving this because you are on the Hidden-Tech Discussion list.<br>
If you would like to change your list preferences, Go to the Members<br>
page on the Hidden Tech Web site.<br>
<a href="http://www.hidden-tech.net/members">http://www.hidden-tech.net/members</a></p>
</blockquote></div>
</body>
</html>