With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Hello, I am setting up a spreadsheet that contains a due date and a date turned in column. I have the conditional formatting set up to highlight the upcoming due dates (7 days out) but I would like the formatting to go away if the 'date turned in' column contains data.
https://productforums.google.com/forum/#!topic/docs/64k4Q3E5UpM;context-place=mydiscussions Need Formula To Calculate Number Of Days To Subtract From Date
I'm trying to figure out how to write a formula which would populate the cells in a column on my first DATES sheet by subtracting day values from a manually entered date in another column. The days to be subtracted are determined by manually entered PLACE values in the same row which correspond to varying numbers as defined on the second DATA page.
There are two conditions which determine whether the PLACE value is valid, however:
Rule 1: If a PLACE value on the DATES sheet is not the colour orange (or if its neighbouring STATUS cell contains data, whichever is easier for a formula to calculate), the days corresponding to this particular PLACE value are not considered.
Rule 2: If there is more than 1 instance of the same PLACE value in the same row (which conforms to Rule 1), only one instance of this value is considered.
Get sum of columns depending on the data in a few other colums
Sorry for the repeat post, I found the post below, which answers what I need to a point. My difference is that I need to look (using this example) for "Anton" in 6 or 7 different columns, not sure how to add the grouping of columns to get my final total. Any help would be greatly received,
Big Russ said:
Further to Ahab's example, you also need to add information about the column of data you are summing, so assuming you meant your example to be:
Column B Column C
The formula should be =SUMIF(B:B,"Anton",C:C) - It is possible to exclude the sum_range as Ahab specified, however I have had mixed results with how the function behaves and tend to explicitly define all aspects of the function for consistent results.
How do you count the occurances of cell data depending on the timestamp month? I've tried
How do you count the occurances of cell data depending on the timestamp month? I've tried COUNTA, COUNTIFS, IFS and SUMIF unsuccessfully.
I have a survey with multiple choice checkboxes (as well as single answer questions). I'd like to sort my results by April, May, June etc based on their timestamp. I've been able to calculate results of all entries, but not separated by month.
My data is in the tab "RawData" and my results, which I'd like to populate, is in the "Analysis" tab.
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/8KOXuradLVA/ZbPnfjqZAQAJ Finding out if this is actually possibly on google sheets
I am working on a google spreadsheet project right now, and I am trying to see if this is possible.
On the sheet I am working on, I have three separate tabs. The second and third tab has a serious of names, separated by first and last name, that number in the hundreds.
Now I am trying to figure out if there is a way or an equation I can use on the first page that will let me know if there are any names that match on the second and third sheet and if those names could automatically be transferred to the first page.
For example; if the second and third sheet both have a "Dave Lee" I would like to see that name pop up on the first page immediately when it recognizes that it is the same.
Is that possible? If it isn't, any suggestions on how I can make this task easier for me?