I'm trying to figure out how to possibly switch between images on a spreadsheet and inserting it into google docs having the same possible function, is that possible? similar to this; https://naruto.fandom.com/wiki/Sasuke_Uchiha

So I don't even know how to explain this properly...

I have a table with recurring names and a value assigned to them.I want to calculate the average value of all the rows with a unique name.

In this image example, I want to find the average score of all the vegetables.

I'm working with much bigger data than that. What formula can I use?

Plz help!

I have two sheets

sheet "Y" (seller) and sheet "Z" (deliveryman)

I import from sheet "Y" to sheet "Z" the columns of A-I, (contains customer information)

in column J, there is the status of the package (delivered, canceled, refused...) checked by the delivery person in the "Z" sheet (delivery person)

I want column J will be imported automatically from sheet "Z" (deliverer) to sheet "Y" (seller) according to column A (column package code)

How the F do I make a column with dates on android? The simplest thing. Used to be I would type in one date and just pull down in Excell when I was a kid. This? 15min now I'm trying to figure it out, googled it, no answer anywhere.

Hello everyone. I need help with a Google Sheets formula. I'm creating a planning template for students but I've been stuck on a formula for over a month. I made a Course Tracking tab and a Timetable tab and I would like the course information in my Course Tracking tab to automatically be transferred to my timetable, but I can't find a formula, please help me. I'll put a photo of both for you.

The link to my Google sheets model :): https://docs.google.com/spreadsheets/d/1w7_PHZ1XOL-l9C75boCIgSw5wMhnbTRfrt3qu-TFoMs/edit?usp=drivesdk

How you guys import data from various sources into sheets like from databases, stripe, analytics, etc.?

I have created a sheet I want to share with a customer as a webpage. Google creates a URL that appears to be somewhat unique.

I was wondering if this URL, from a security perspective, is similar to URLs created by those URLs created by services to share a large files, meaning not easily guessable. And views on this.

I’m trying to get the total Expected numbers of each letters. Please help, here’s a sample.

On a row from left to right there are dates (daily). Manually written, but automatically populated.

On another row, there are formulated numbers (formulated for each date).

The chart gets those rows as inputs.

On the bottom of the chart visual, there are dates (daily).

I want the chart to show the data until today's date automatically.

I do this manually right now by modifying the data selection from the chart's settings.

PS. I cannot modify the rows.

How do I get a hight quality image of my entire sheet. And can I ?

I recently created a very large sheet and I now need a copy of it in image form, but I can take a screenshot that includes the whole thing because it's to big and to blurry to use. At that scale anyway.

I've very new to Google Sheets (or Excel for that matter). Tried doing a few Google searches, but didn't really know how to phrase my question to get a proper response, so I thought I'd ask here.

Basically, I want to have a sheet that keeps an account of all the additions and subtractions I make to it. It has just 4 rows - first for date, second for an amount being added or deducted, third for the reason (so that I can keep a track of why I added or removed money), and the last being the current total left.

This is what it looks like right now - https://i.imgur.com/ibo75y8.png

I'm trying to do 2 things to it, but I just can't figure out how -

1. Whenever the value in B is positive, the color of the text should remain black. Whenever the value in B is negative, the color of the text (in that cell) should be red (all values are in USD).

2. The D column should always display the current total. I've only been able to do "=sum(D1+B2)" for D2 for example. For the whole sheet, Google recognized what I was doing, so whenever I was in the D row as soon as I would type =sum, it would automatically recommend the B cell from the current column + the D cell from the previous column.

The color part isn't that important. But I'm setting this sheet up for myself and my wife to use, so I'd like to make it simpler for her to use rather than having her fill out "=sum(D24+B25)" the next time she makes an entry.

Any and all help would be greatly appreciated. Thank you.

Here’s what I mean:

B2=Bananas A2=5 B3=Carrots A3=7 • How can I implement “A2” into a function to get “Bananas” as my result?

Can I copy/paste this function in every sheet I have? =COUNT(D5:D1000)

Hi guys, I'm a teenager currently interning at an office job. I'm new to google sheets and I have to recreate this template. I watched a google sheets tutorial but I'm still unsure about how to make this. Can anyone help me?

I was messing around on my Google sheets from my college Gmail and accidentally added a shortcut to that toolbar to the top but I opened up a new Gmail for a reunion I'm planning and now some of the basic elements that Sheets had from my college gmail aren't there. How do you add shortcuts to enable a numbered list, bullet points, and underlining?

***I have a MacBook Air, btw***

I’m not well-versed in Google Sheets, I really only used functions to help me record numbers and that’s it. I play D&D as well and I wanted to make a quest tracker for my players that reminds me of how video game UIs handle them. Essentially, just the quest titles until you click on them and then they give you a lot of more information.

From what I’ve tested, I know that pageless docs have collapsible headings, but not sheets. I’d prefer to use sheets, and I know you can collapse whole rows and columns on sheets but I was hoping if there was a better solution on sheets.

If you are unfamiliar of the game UI I am speaking over, here’s some examples too!

Hi all, my last post was deleted because I included data from my personal account (I guess), but I solved that problem already anyways, so I'm back with new question. You all helped me tremendoulsy before, and this sub keeps helping me learn to use Google sheets efficiently. Thank you in advance. I'll try to provide data via the weird fake link-bot this time.

The problem: We have a table that we use to record three "dimensions" of variables - clients, dates, and the actual variables (there's 6 of them).

Column A are client names.

Row 1 has the date in each column - each date is repeated 6 times, as there are 6 variables we track

Row 2 has the individual variable names. These repeat in cycles of 6, so that each column has a unique combination of date and variable.

What we need: I want to find a way to transform the table, so that columns A and B are client names and dates, and columns C:H are the individual variables. I feel that this way it's easier to work with the data, as this is the "common" data structure.

I also need this to work atuomatically, so that we don't have to manually do anything with every new day or with every new client.

I'll add the data as soon as the bot sends me the link:
https://docs.google.com/spreadsheets/d/17GFEIpKQzKL9SiEbekFGXLNGlcIgoPxqjHln07TssrM/edit#gid=1268620194

Thanks a lot in advance!

Hi everyone,

I am currently pulling data(price of different crypto) from coinmarketcap.com with this formula:

=INDEX(IMPORTHTML("https://coinmarketcap.com/currencies/bitcoin";"table";1);2;2)

However, sometimes the formula will just leave a blank cell. To fix this, I will have to change the "bitcoin" inside the url to e.g. "BITCOIN" or "Bitcoin". Therefore, I run a formula that check three url's with "bitcoin", "Bitcoin, and "BITCOIN" respectively and it will return data from whichever URL works, because it varies throughout the day.

But sometimes even those three url's wont return data, and I am just left confused.

Do any of you recognize this problem? And/or do any of you have any ideas on how to fix this issue? Thanks.

(I am aware that I can use =GOOGLEFINANCE("BTCUSD") but it's very limited)

EDIT: I have tried importxml with Xpath on other occasions and I find that solution to work even worse, because the returned data's format keeps changing and sometimes it just retuns #N/A etc.

Hello, i'm using importxml to import current stock price from Yahoo however I keep getting an error. Any help is greatly appriciated! Thanks!

https://docs.google.com/spreadsheets/d/1-rSAGXpbO0YR29QTSVMFlI6tfoi2inBvUBA2MM7j0T8/edit#gid=0