Chris5626

成为会员时间：2019/10/13

成就

要开始获得徽章，请注册参加我们的产品专家项目，成为产品专家。

活动

	社区指南
	社区视频

	问题
	所有回复

推荐的回复

帖子历史记录

回复 There is no option to download a show i just purchased

Google TV•2024/5/21

No idea why but Google seem to have removed the download button for TV shows on Google TV for Android from the show's page.

To find it you go to the show you want to download then press the 'Google TV Buy episodes' button (even though you already own the show) THEN the download button should be visible next to each episode.

回复 Counta with multiples - Formula to count occurrences of numbers

Google Docs Editors•2024/4/18

Thanks Ben, that looks like it does exactly what I wanted it to do.

Can I ask, the formulas I was trying (column I) how far off was I? It looks like my formulas worked fine for single numbers but not multiple, the equation you've used clearly works but I don't think I'd have ever been able to write that.

回复 Counta with multiples - Formula to count occurrences of numbers

Google Docs Editors•2024/4/18

Hi Ben,

Sorry forgot the sharing settings, have now granted edit access but I'll give this a try when I get a chance.

Counta with multiples - Formula to count occurrences of numbers

Google Docs Editors•2024/4/18

Hoping someone can help with a formula?

Aim

I have a spreadsheet which I need to use to create some charts.
The spreadsheet contains various dates from the start to the end of a process.
The charts I need to produce need to show the percentage of how many days it takes for specific stages of the process to take.

Single Number Formula

For single numbers I think I have the formula right:

=counta(arrayformula(iferror(search("0",Sheet1!E2:E5))))
In this example it should count each time the number is 0 days.

=counta(arrayformula(iferror(search("1",Sheet1!E2:E5))))
In this example it should count each time the number is 1 days.

Multiple Number Formula

But I'm not sure how to write it if I want it to include multiple.

=counta(arrayformula(iferror(search("2:5",Sheet1!E2:E5))))
I thought would give me the number of occurrences between 2 and 5 days. It doesn't.

Spreadsheet

I've included a section of the sheet below which probably explains much clearer. Any chance someone could take a look? Thanks in advance!

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

5 条回复

Google TV•2023/12/17

I currently purchase movies and TV shows via Google Play which are eligible for my family library.

"Starting 17 January 2024, Movies & TV will not be available on Google Play, but you can make purchases and find your past purchases on YouTube or Google TV."

As I understand it, when buying movies and TV shows from YouTube they are not eligible for my family library but purchases from Google TV are. Is that correct?

Also, is there a way to buy from Google TV via a web browser? The app is really poor for trying to find content to buy, for example if I go to the 'Shop' then 'Shows' there is no way of looking for new releases, top sellers, special offers etc.

If you know exactly what you want to buy that's ok, you can search but if you want to explore it basically just presents you with the content you already own.

9 人点赞

2 条回复

回复 Pixel 8 Pro USB Type C External Display Output?

Google Fi Wireless•2023/10/15

I've seen a couple of theories that seem credible as to why this hasn't been included so far.

One being that Google are worried about negativity impacting their Chromecast products. Obviously there is a lot of crossover in wirelessly streaming a display or content versus doing so by a physical cable, that said there are a lot of situations where a Chromecast isn't viable but where USB-C to HDMI or DisplayPort is and visa versa so I can't see this having a significant impact but I can understand someone somewhere thinking it's a problem.

The second one being that it's to avoid upsetting other Android OEMs. If the Pixel phone does everything then it grabs more market share from other Android manufacturers, manufacturers that Google need to keep inside as they rely on them. Samsung for example did a lot of work with Google on getting their watch OS up to scratch so Google probably doesn't want to upset Samsung by 'stealing' DeX, there might even be a formal agreement.

The 2nd of the 2 makes more sense to me but they both feel credible.

That said, DisplayLink adaptors do work with Pixel phones so there is a way of doing video out via a cable. It has just two main issues:

1) the adaptors/docks are expensive and much bulkier than just a cable

2) the Android app is terrible (2.7 stars at time of writing)

So Google have implemented a way of doing it, it's just the worst option on the market by far.

Ultimately though I suppose why Google hasn't implemented it is less important right now than why Google said it had when it hadn't.

15 人点赞

Google Fi Wireless•2023/10/14

Can anyone from Google confirm if this is going to be added post launch and if so when?

This is an important feature for me so I made sure to check with Google before pre-ordering and they told me it was supported.

"you will be able to connect your Pixel 8 Pro to an external monitor or TV using a USB-C to HDMI or DisplayPort cable. This is a new feature for Pixel phones, as previous models have not supported video output over USB-C."

"I have asked from the higher support and yes, it is supported."

It looks like a lot of customers have wanted to confirm this before pre-ordering/purchasing and I've seen several people posting screenshots of their chat logs/emails with Google, within which they were being told that both the Pixel 8 and the Pixel 8 Pro support this.

So either Google thought this was supported or the support is coming later.

回复 Google Discover Feed not working

Google Search•2023/7/24

Just a quick update. A day after my last post Discovery started to work again but intermittently. It seems to now go through extended periods of working fine before not working again but I can't discern any kind of pattern to when it works or doesn't work.

回复 Google Discover Feed not working

Google Search•2023/7/20

Hi John2857,

Just to check does Discover feed work again if you aren't signed in or when you turn off 'Web & App Activity'?

Just trying to check if we both have the same problem with the same underlying cause.

Additionally, when did the issue first appear for you?

回复 Google Discover Feed not working

Google Search•2023/7/20

Thanks Davinder_Singh,

I'm not expecting Google to make changes to the app to deal with my issue and if they were to do so I would imagine that would take some time, I've posted the issue here in the community in the hopes that someone might be able to suggest something I can try my end to resolve the issue.

回复 Google Discover Feed not working

Google Search•2023/7/19

Thanks Davinder_Singh

If you tried everything like clearing cache, re-install Google App, etc. Then, probably, there is an issue with the data stored in your Google Account.

That was my thinking as well, I've tested on 3 different devices all of which have the same issue, since the issue is not present when not signed in this confirms the issue is neither with the device nor with the app itself.

The only way to reach Google is Send Feedback.

Open Google App > tap top right profile picture > Help & feedback > Send feedback.

I'm aware of how to give feedback and I have done that however my motivation isn't to give feedback but to find a solution.

回复 Google Discover Feed not working

Google Search•2023/7/19

To add, this appears to be the exact same issue posted HERE, sadly the question is locked and replying has been disabled so I don't know if anyone found a solution that wasn't posted.

Google Discover Feed not working

Google Search•2023/7/19

Up until a few hours ago my Google Discover feed (accessed either via the Google app or by swiping from the home screen) was working fine.

Now it says
"Something went wrong
Couldn't connect to Discover"

I've tried on 3 different Android devices and have the same issue. If I 'Use without an account' it works fine but when signing back in it again displays the same error message. This allowed me to determine the issue was not an issue with my device or with the app itself.

The only way I can get Discover to work, whilst signed in, is to turn off 'Web & App Activity', however as soon as I re-enable 'Web & App Activity' it stops working again.

The subsetting 'Include Chrome history and activity from sites, apps and devices that use Google services' seems to make no difference.

I have deleted all of today's activity for all Google services via https://myactivity.google.com/ however it hasn't made any difference.

Can anyone suggest a solution?

521 人点赞

13 条回复

Video playback pauses when locking mobile phone

Google TV•2022/6/29

I have a Chromecast with Google TV.

When watching videos, it seems regardless of what app I am using e.g Disney+, Google TV, YouTube playback pauses whenever I lock my phone despite the fact that I'm playing the content on the Chromecast natively rather than casting from my phone.

Has anyone encountered this and does anyone know of a fix?

3 人点赞

1 条回复

回复 How do I get purchased videos to play in order?

YouTube•2021/8/7

Anyone have any idea about this?