2,552 reputation
413
bio website Blogger-hints-and-tips.blogsp…
location Ireland
age
visits member for 3 years, 9 months
seen 2 days ago

Apr
16
comment Drive document don't display on Google site
What permissions does the document have in Drive. And how are you doing the insert into the GoogleSites site?
Apr
16
comment Reflect changes in on sheet to another on Google spreadsheet
I'm not really keen to do that: I while your answer is technically correct, it only covers some columns (which you haven't explaned) and the case wehre every single cell in the 2nd sheet is to be the same as the first - and it does this by putting a formula (which you haven't explained) into the other cells in sheet2. I just don't see any real-world applications for this approach: if every single cell is to be the same, then why not just reference the first sheet.
Apr
15
answered How to search multiple sites at once?
Apr
15
revised Reflect changes in on sheet to another on Google spreadsheet
deleted 1 characters in body
Apr
15
comment Reflect changes in on sheet to another on Google spreadsheet
Yes, that is correct. If you want the soluiton to by dynamic, and to work no matter how many rows are added, then you need to use a script which is run each time that someone updates Sheet1. But in many common spreadsheet uses, this degree of complexity is not necessary.
Apr
15
answered Reflect changes in on sheet to another on Google spreadsheet
Apr
15
revised Blog readable only by people signed into a certain Google domain?
made some phrases clearer
Apr
13
reviewed Approve suggested edit on Can't get into my Gmail account
Apr
13
comment How to share Google Drive folder without sign in required to view
And I can see into the folder now, too. I guess this is because you've set it to pubic.
Apr
10
comment How to share Google Drive folder without sign in required to view
Drive is not guaranteed to work in IE 8 at all: at the moment only 9 and 10 are supported, as soon as 11 moves out of Beta, it will become supported and 9 will no longer be. (And actually, this is a significant issue in using Drive to share things with "the public")
Apr
10
comment How do I merge columns but preserve data Google spreadsheets
Can you draw us a sketch of what you are trying to acheive? I really cannot visualise what you mean by "combine column A and column B"
Apr
9
answered Blog name disappeared in Facebook share
Apr
8
answered Unified standard for publication date and author name in newspaper articles
Apr
8
answered Where are the conditional formatting custom formulas?
Apr
7
comment Blog name disappeared in Facebook share
Did you install the OG tags, or are you replying on the ones in your template?
Apr
7
answered How to share Google Drive folder without sign in required to view
Apr
7
answered How can I get Outlook to auto-accept meetings?
Apr
4
comment Google Sheets referenced cells and sorting
Good move - that's not a workaround, it's the simplest answer.
Apr
4
answered Add existing gmail account to an existing google account
Apr
3
comment Google Sheets referenced cells and sorting
What type of forumula are you using to get data from Sheets 1 and 2 into Sheet 3?