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

Oct
21
comment How can I publish a word document on the same URL but changing content from time to time?
A filing cabinet is a type of "page" in Google Sites. You make it, and put your file into it - and then you can get a URL for the file which can be used elsewhere.
Oct
16
comment Send from Gmail with another email address as the Reply-to or From address
This approach no longer works: Google requires the "send from" email address to receive a verification code which is then entered before the the Google setup can complete.
Oct
8
comment Circular Dependency Error, Blank when 0
What cell are you putting the formula into?
Oct
7
comment Error: Circular dependency detected
I cannot see one from what you have posted - but it's hard to tell with a picture. But I have just confirmed that =countif(A8:C12, "Free") should work. See here for an example: docs.google.com/spreadsheets/d/…
Oct
1
comment Can I get a URL to the latest PDF version of a document?
I don't think that the Manage Revisions tool will help. The fundamental problem seems to be that poster needs to update a Google Docs file regularly, and then make a PDF from it, and then share it. Even with Manage Revisions, these steps won't go away. The only part that it would help with is that the document URL would not change.
Sep
30
comment Can I get a URL to the latest PDF version of a document?
Why do you need PDF format?
Sep
25
comment Tweeting without annoying others
O)k - so why don't you post that as an alternative answer, which does address the original question.
Sep
18
comment Tweeting without annoying others
But it won't let readers easily find the artist, so fails to address the problem.
Sep
18
comment Can I hide from “Shared with Me” the documents others users shared with me?
I don't read it anywhere. But my experience with Google products is that the don't share details of the product roadmap, far less detailed changes with us, unless those changes involve standard uses. You are proposing a non-standard use, and that is always a risk. You could easily find that one day deleting a file from the Shared with Me list revokes your access to it.
Sep
17
comment Can I hide from “Shared with Me” the documents others users shared with me?
None that I know of today. But Drive is designed around the idea that the Shared With Me folder contains a sortable list of all the documents that have been shared with you, and the idea that you will use search, not folder structures, to find the one you want. There are no guarantees that a alter version of Drive will not change how it handles files if you attempt to "move" them from the Shared with Me list. And as Google often don't announce feature changes, you could do some damage.
Sep
16
comment Can I hide from “Shared with Me” the documents others users shared with me?
I wasn't trying to be witty: the poster is asking to have his cake and eat it to. Google simply doesn't provide any mechanism to organise "shared with me" files at the current time. Any work-around with the Move function may well cause problems with the future versions of Drive.
Sep
16
comment Spreadsheet not sorting properlty
You need to tell us more about the spreadsheet and how it was made. Ideally, make it public and give us a link to it.
Sep
15
comment How to have The Old Reader show more than the 10 first items of my RSS feed
I have a feeling that The Old Reader only shows items for 30 days - could that be the problem? If it is, the I think the only fix is to move to another RSS reader (I went to inoreader)
Sep
12
comment Export blog entries from Blogger
This doesn't do what the question asked for. It generates an xml file which has links to the image-file (wherever it's hosted), nto the actual image.
Sep
3
comment What are the advantages of having custom domain for blogger?
If your ads are AdSense, then the problem is that you signed up through the quick and easy hosted option, but that isn't available for custom domains. Remove your ads, and then go to www.adsense.google.com and go through the full signup process - this includes placing some test-ads in using HTML-gadgets.
Sep
3
comment What are the advantages of having custom domain for blogger?
No, a custom domain does not necessarily mean more traffic. There are opinion-based arguments about whether it might cause you to look more attractive in search-results - and alternative opinions that the quality of your content has a bigger effect on this. But the fact-based answer is that there is nothing intrinsically better about custom domains.
Aug
28
comment How to mix numbers formula in text format to formula format?
Alternatively, change A1 to =8/39 etc (so it displays as a decimal value), and then the simple approach will work, provided you divide it by 39 too. Fundamentally, though, this looks like a design problem: you should probably have the two parts of each cell (eg the 8 and the 39 in cell A1) in two different cells, and then do the maths you want on them in another cell.
Aug
28
comment Google Sheets Suffix To Column Cells
Why do you need to use the PowerTools add-on? Won't ordinary copy-and-paste do the job?
Aug
21
comment When does the next year become available as a start date in LinkedIn?
I'm pretty sure that LinkedIn is for recording what you HAVE done, not what you PLAN to do.
Aug
20
comment Why is Google hiding the search input field?
Happens to me that way too: work is Win 7. Home is Win 8.1