3,211 reputation
615
bio website Blogger-hints-and-tips.blogsp…
location Ireland
age
visits member for 4 years, 3 months
seen 15 hours ago

Aug
12
comment How to archive all the posts from a Facebook Page?
Please define what you mean by "archive". Delete? Take off-line to most people can't see them but you have a copy somewhere else?
Aug
12
answered Google Spreadsheet changing cell references on its own
Aug
11
reviewed Reject suggested edit on How can I give permissions to access Google Docs document for non-Google users?
Aug
11
answered How can I append a string to a formula result?
Aug
7
comment How to handle Negative Time Delta in Google Spreadsheets
I was working on it as you typed! See below.
Aug
7
answered How to handle Negative Time Delta in Google Spreadsheets
Aug
7
comment How to handle Negative Time Delta in Google Spreadsheets
That will only work in cases when the later time is in the morning and the earlier one is in the afternoon.
Aug
1
reviewed Reject suggested edit on Sending notifcations from a facebook page's email account instead of sending the notifications to the user?
Jul
30
comment Easy way to mention my own blog link?
fyi, I decided to investigate the issues behind this question in more depth. The answer above does not change. What I found, and some other relevant info, is here: blogger-hints-and-tips.blogspot.co.uk/2014/07/…
Jul
30
comment How to make Google speak British English?
Which particular British accent did you have in mind - Cockney? Geordie? Scouse?
Jul
24
answered Easy way to mention my own blog link?
Jul
23
reviewed Approve suggested edit on Google Docs Insert Special Characters show as boxes
Jul
22
comment How can I make Google Sheets tell me how many of each date are in a column?
Just put it in as many rows as you might realistically every have.
Jul
22
comment How can I make Google Sheets tell me how many of each date are in a column?
You need to put the formula in as many rows as you think may realistically by used. Up to 65,536 if you expect that much data - but if you do, you really should be building a solution in a robust database that's scaled for the problem at hand, not using a spreadsheet!
Jul
22
answered How can I make Google Sheets tell me how many of each date are in a column?
Jul
22
comment Someone's Google account under my domain, how to ask for removal?
If someone wants to lie to other people and mailing list, and say that their email address is theirName@yourDomain.com then there is nothing you can do in the on-line world to stop them. Maybe you could get a court order for harassment (or something) - but only if you can track down who the person is in real life. Good luck with that.
Jul
21
answered Someone's Google account under my domain, how to ask for removal?
Jul
18
answered Google Forms - Checkbox - Other
Jul
18
answered Trying to query one sheet to inform another
Jul
18
answered Google Forms - Checkboxes - Edit Option