Blog

I am able to get todays high / low / open with below formula correctly. =INDEX(GOOGLEFINANCE("NSE:CIPLA", "HIGH")) but not able to get todays close with below formula. =INDEX(GOOGLEFINANCE("NSE:CIPLA", "CLOSE")) it gives below error -> "Function GOOGLEFINANCE parameter 2 value is invalid for the symbol specified" the question which is answered here > How to getRead more

How can I get a list of Sheet2!A2:A cell values where (Sheet2!B2:B= "Yes") and (Sheet1!B2:B less than 200) (ignoring values that are in Sheet1!A2:A but not in Sheet2!A2:A) https://docs.google.com/spreadsheets/d/1TPXl4qnUcufrbBZ-mEoz6LPEiL_XtXw374r0IDITudg/edit?usp=sharingRead more

I couldn’t find the option. I looked at: https://www.concursolutions.com/Expense/Client/default.asp: https://www.concursolutions.com/Expense/Client/default.asp -> expense report -> click on one expense I couldn’t find any info on Google. https://sapconcur.psu.edu/faq/how-do-i-delete-attached-receipts only deals with receipts that are attached to a report.Read more

I currently have a Google spreadsheet that keeps track of all orders and the progress: Column 1: Order Form Sent Column 2: Order Form Received Column 3: Delivered to Pick Up Site Column 4: Picked Up For those columns, I have entered checkboxes with data values of "true" or "false." On my sheet, there areRead more

I just changed my password & google verified that but why would a different city than mine show up?Read more

I could be getting a call in Facebook Messenger (heard the beeping), and accept the call on the computer, and start talking, only that now the iPad in the study room, and the iPhone in my jacket or pants keep on beeping NON-STOP. I was at first going to just keep on talking and hopeRead more

I have a business Instagram account linked to an Ad Account in Facebook Ads Manager. While I can successfully use the videos posted with this Instagram account to create ads, I cannot use them to create an engagement custom audience.Read more

I’m trying to create a daily personnel report. Each manager needs to report who their personnel are, whether they are Present, Sick, On Leave, etc, and where they are. I then plan on having a set of Sheets collate and organize the data, creating a summary for the director. Each day, we’ll save off aRead more

I have a Google Form that asks people to fill out their name, gender, and then their size preference for shirts and pants. The form automatically outputs the 2 sizes in separate columns. I want to combine the size columns while retaining the name and gender of the respondents, like this: I know I canRead more

I am working with a fee sheet that goes up in $ increments based on time and I would like google sheets to do the math to calculate the cost based on the time entered into a cell. EXAMPLE: a time value of “1” entered into a cell will always equal $ 800. Every additionalRead more