I have a google spreadsheet and all the columns are continuously updating based on the website values. Is there a way to record the highest value that a cell had during all this time/for a particular period?
It is like recording the last 24 hour high for financial markets.
Currently I am computing the date difference in days using this formula (which works): =if(and(ISNUMBER(W2),ISNUMBER(H2)),W2-R2,"")
However, I would like to restrain the output and only consider values between 5 and 150.
So I would like the function to say If W2 isnumber and if H2...
For a personal project, I am trying to build an application for data collection. This is the idea for the application
1. The user enters data into the spreadsheet template using either an android mobile phone or chrome browser
2. Each week, the user creates a new spreadsheet from the...
I'm using Google Sheets and am trying to get this formula to work to give the me the following count:
Count when Column T = Kenneth AND Column U = (Pending OR Contacted) AND Column W has a date that falls between the dates shown in B14 and B15.
This is what I have so far...
I'm running an email script which works fine but only want it to run through the last row with data in it. I don't need it or want it to run if there is no data obviously. How do I reflect that in the example script below?
For example, say there are only 3 rows of data in my sheet...
Row B=Status (In Progress, On Hold, or Completed)
Row C= Task Description
Row D= Start Date
Row E= Estimated Completion Date
Row F= Actual Completion Date
Cell I5=Date (Part of a series of dates within the calendar month)
So, I'm creating a gantt chart in google spreadsheets and need to have bars fill in specific colors based on the start date, estimated completion date, todays date, and the tasks progress. In other words, I need the time between the start date and estimated completion date to be gray. As...
This is technically not an Excel question but about Google spreadsheets because I know how to do this on Excel but it won't work on Google spreadsheets.
I need to count all total instances of the word "Freelance" in a column A with a corresponding value of "London" in a column B...
I have used quite a few COUNTIFS formulas in Excel that do not translate into Google spreadsheets. I was wondering if anyone would know how to translate the following formula into Google spreadsheets...
I very much appreciate any and all help in accomplishing this objective as follows:
I have an online survey which has 9 list box questions. The only options for each question is "A" or "B". When the form is submitted I will have one row with some "9 column permutation" of "A's" and "B's". Each...
Anyone heard of a decent way to import spreadsheet data from Google Spreadsheets into an excel document so the resulting excel spreadsheet has live updatable google spreadsheet data?
Pharmacist from Queensland, Australia