489

Solutions

770

Contributors

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

I have a 'totals' sheet that pulls stats for matches on a sheet named by the date the match(es) were played on.
On my totals sheet, I have each athlete's data listed under their name, by match, so they can see how they've (hopefully) improved throughout the season.

The problem is, I have to manually copy/paste/adjust the cell formula for each match.

Example:
On 9/5 we played Team A & Team B.
On the totals tab, I list "Cindy" and her data for certain skills for those matches.
Column A would show "9/5 Team A" and the next row would show "9/5 Team B".
In column B I would normally reference "='9/5'!B17" to pull her data for that stat.  Then I could copy/paste it for each skill recorded during that game.
Next row, I'd repeat, but it would need to read "='9/5'!B31" (there are 14 rows between the same skill of each subsequent match).
Then I could copy/paste for that entire match as well (meaning column C becomes "='9/5'!C31").

I want to figure out a way that I can copy/paste based on some moving criteria.
I can reference the sheet name dynamically by using
=indirect(left(A119,3)&"!B18")

But, obviously, I can't copy/paste that for columns C forward, I have to manually increment the column.

Secondly, if there was a second (or multiple) matches, I'd like to be able to dynamically increment for the next row:
=indirect(left(A120,3)&"!B32")

Finally, if there's a way to do this based on the athlete's name, the first Athlete's name begins on A37 of Totals, andâ€¦
0
How can I sum up a number of rows which contact text rather than numbers?  Essentially what I am looking for is a cell to contain an answer to =count the number of rows as I add new rows
0
I have had issue connecting to my CAS servers.  They are VERY persistently looking for a failed one.  How can I find/view/change these settings?  I have search up an down through outlook and google.  I am on 2013
0
I have a lenovo a10-70f that only boots into recovery mode. I choose a command and I get the dead android logo with a triangle coming out of its stomach with a caption "no command"

My diagnostic is that the OS updated and screwed up, I've seen it similarly before with Google Play soft-bricking the entire tablet.

There is an option to update from from, does anyone know where I can get a copy of the original android image for this device? And where can I get a copy of the fastboot adb.sh file? I had it a while ago, and I lost it when my server mobo died.
0
When I try to recover the gmail password

it asks me to type the email.
first name and last name
then I get this error: No account found
There's no Google Account with the info you provided.

I have one old iPhone still connected to that gmail.

- can I have gmail send a password reset link to my account?
0
I have an https share link from google photos which works perfectly. However, I do need this link to launch from within an iframe tag.  I cannot get the page with the iframe to launch the google photos share link.  I wonder if it is possible to do this, and if so - what am I missing.

Share link is https://photos.app.goo.gl/bb4C8luWTmlcQbXu1   This works from browser.

I am attaching the page which has this link embedded within an iframe.  This does not work.

<iframe src="https://photos.app.goo.gl/bb4C8luWTmlcQbXu1"
width="100%" height="3000">
<p>Your browser does not support iframes.</p>
</iframe>

0
Dear forum contributors,

I'm experiencing a issue trying to use Google Cloud APIs with Python.
My cenario:
=== Hardware and OS ====
OS Name      Microsoft Windows 10 Pro
Version      10.0.14393 Build 14393
System Manufacturer      LENOVO
System Model      20BGCTO1WW
System Type      x64-based PC
System SKU      LENOVO_MT_20BG
Processor      Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz, 2394 Mhz, 4 Core(s), 8 Logical Processor(s)
BIOS Version/Date      LENOVO GNET73WW (2.21 ), 03/12/2015
SMBIOS Version      2.7
Embedded Controller Version      1.11
BIOS Mode      UEFI
BaseBoard Manufacturer      LENOVO
Secure Boot State      Off
PCR7 Configuration      Elevation Required to View
Windows Directory      C:\WINDOWS
System Directory      C:\WINDOWS\system32
Boot Device      \Device\HarddiskVolume2
Hardware Abstraction Layer      Version = "10.0.14393.206"
Installed Physical Memory (RAM)      32.0 GB
Total Physical Memory      31.9 GB
Available Physical Memory      18.7 GB
Total Virtual Memory      36.6 GB
======================
=== Python version 3.4.4

When I try to run the command 'gcloud init':
Welcome! This command will take you through the configuration of gcloud.

Your current configuration has been set to: [default]

You can skip diagnostics next time by using the following flag:
gcloud init --skip-diagnostics

Network diagnostic detects and fixes local network connection issues.
Checking network connection...done.
Reachability Check passed.
Network diagnostic (1/1 checks) passed.

ERROR: gcloud crashed (UnicodeEncodeError): 'ascii'â€¦
0
Latitude 3440/Windows 7. This is a new issue never experienced before while in projection mode (F1), using "Mirror" (so that I can work on the laptop while others can see what I'm doing on the big screen).  The cursor is in the correct place/orienation on the big screen, but is completely whack on laptop screen.  If I'm aiming for the task bar, it's correct on projector, but pointing upside down and at the top of the screen on laptop.  Mousepad too.  it's perfectly fine when not in projector mode. I thought maybe someone had mucked with the screen resolution, but changing that didn't help.  Google unhelpful. Any ideas on this?
0
Hi,

I have built a small wordpress widget that floats in the bottom right hand corner of my client's website(s), so that their users can click it to make a payment to them... which simply redirects the user to my payment platform / website where my customer has an account.

FLOW - widget sits on clientwebsite.com and when they click it, the customer is brought to mysplink.com/abc (their payment profile on splink)

QUESTION
I need to be able to track how many users land on mysplink.com from a widget that sits on another site.

I was thinking of using something like mysplink.com/abc/ref=widget-abc and then i can view that in Google Analytics?

01 - would this approach be the best way to do this?

02 - any other advice on approaches would be greatly appreciated

0
My OS is win 10 prof 64 bit and i use Google Docs to format my documents then to publish it in Google Groups.  Sometimes I have graphics and I am sure they may not show up on some pcs, and to overcome this, I thought of having a line :
But how do I implement this, that will take the message viewed and display in a browser.
Thank u and regards.
0
I AM NEW  TO THIS!!

LOOKING TO ADD FIELD TO CLIENT REGISTRATION FORM FOR PEOPLE TO ENTER ASSIGNED CLIENT NUMBER. THE FIRST FOUR NUMBERS HAVE TO BE ENTERED AS 2017 TO BE FOLLOWED BY A HYPHEN AND FIVE MORE NUMBERS THEY WILL BE ASSIGNED RANDOMLY. PLEASE AND THANK YOU FOR YOUR EXPEDITED ANSWERS.
0
Hi all,

I need an idiots guide to tracking forwarded pages.  I understand most of the concepts, but the analytics interface is mostly a mess to my eyes.  Here are my intentions:

1) custom domain  example.com , example.com/1 and example.com/2 exist
2) each independent URL forward to the same destination contoso.com (where tracking is up and running fine)
3) Be able to track and trace the traffic hitting example.com, example.com/1 and example.com/2

Tools at my disposal:

2) Full domain access at the registrar level
3) Webserver control for example.com (using plesk, have Wordpress installed to it right now in an attempt to make it easier for client to do some of the page creation, but can abandon in favour of custom php pages index.php, 1.php and 2.php for instance)

If there is a clear and concise document(s) already written, please link.  When I go hunting, I find people with posts that tell half the story.

Cheers,
0
Hi,
I am using a small code in Excel but know need to use it in Google Sheets,but im not able to convert the code to google sheets

Code as below:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim temp As Range, max As Range, min As Range

Set temp = Range("A2")
Set max = Range("B2")
Set min = Range("C2")

If Not Intersect(temp, Target) Is Nothing Then
max = WorksheetFunction.max(Target, max)
min = WorksheetFunction.min(Target, min)
End If
End Sub

Thanks and Regards
0
Hello All,

Chrome Extension ID where will able to Create GPO User Configurations or Computer Configurations?
Which is the Correct Method to follow?
0
I have inherited a web site (WordPress) that uses Google Forms to gather form info on the web site.

I don't know what it does with that info, how to access it, how to send the completed form info to intended recipients, etc.

Is there somewhere documentation on how to manage Google forms?

I want to use what has been developed without re-inventing the wheel, I may have to.

Thanks
0
I'm trying tomake this chart responsible but I cannot...
what should i do

<html>
<script type="text/javascript">

function drawChart() {
['Year', 'thousand tons', 'million dollars'],
['2004',  201328,      756000],
['2005',  233917, 876000],
['2006',  248957, 986000],
['2007',  277151,      1228000],
['2008',  300836,      1487000],
['2009',  284747,      1226000],
['2010', 309451 ,      1302000],
['2011',  326247,      1585000],
['2012',  347526,      1672000],
['2013',  363336,      1791000],
['2016',  385120,      1920000]

]);
var options = {
title: 'Company Performance',
curveType: 'function',
legend: { position: 'bottom' }
};

chart.draw(data, options);
}
</script>
<body>
<div id="curve_chart" style="width: 900px; height: 500px"></div>
</body>
</html>
0
Our website is in JPEG format.  My understanding is that Google wants the contents of the website to be in HTML.
How could we change the contents of the website to be HTML. Our website has about 2000 pages.

0
To sync both directions is iCloud good ?

Customer has 2000 contacts there in iCloud and wondering is sync both directions possible from this modern galaxy ?

Is it easy to config ?

Thanks
0
I'm setting up 20 Chromebooks for a small private school and it's a first with Chromebooks and the chromebook management software for me.  What I'm trying to figure out is this...
They thought about assigning one Chromebook to 3 students but the other option (easier) is to allow any student to log into any of the Chromebooks.  The problem is I'm concerned the 16 gig drive will fill up if people start keeping things in the downloads folder and/or if user settings are stored locally.  Is there a way to keep this from happening?  Each student will have there own login credentials and google drives under the GAFE account.

We want to utilized the Monitoring and Reports options that is available through the management software. But, I also see that I can't enable the option "Erase all local user info, settings, and state after each sign-out" otherwise the logging won't work and this where I'm stuck.  Not sure how to get around not being able to use the Erase all local user info at log off option yet not have to worry about the drives filling up if a bunch of students log into the same Chromebook.

I started looking at how the "sync user settings and data" option works but I'm still unclear as to the best option for this sinario.

Thank You!
0
I have a network that I need to create some Google Chrome Polices on Windows PCs.
I need to have Chrome NOT remember the Google account when the browser is closed.
I have public PCs where users are logging in to Chrome and then the next user can access their personal settings in Chrome which is the problem.
I am not on a domain, just a workgroup.
0
Is there a way to easily do this?

What the best way?

Thanks
1
I'm working with Google Tag Manager for the first time.  I've setup the container and added tags.  But the green box says "Container Not Published" "Add tags and publish to make your changes live"  When I click to add tags, there are no tag Versions to make live and the tag, trigger, and variable count are zero.

I've attached a screen shot of the tag manager Workspace in hopes that helps.

Thanks!

Steve
0
I have a client that has a Google Adwords account.  The account was suspended.  The message read:
Your AdWords account has been suspended because it does not comply with our "Misleading Content and Missing Information" policy on untrustworthy behavior.
Policy violation:
Untrustworthy behavior

I have scoured the site and read all of the documentation and for the life of me cannot find what the issue may be:

URL: https://www.ein-irs-tax-id-number (DOT) com
0
The file content-search.php on my WordPress site has this content:

``````<div class="row">
<div class="span12">

<h1>SEARCH RESULTS</h1>

<script>
(function() {
var cx = 'xxxxxxxxx';
var gcse = document.createElement('script');
gcse.type = 'text/javascript';
gcse.async = true;
gcse.src = (document.location.protocol == 'https:' ? 'https:' : 'http:') +
var s = document.getElementsByTagName('script')[0];
s.parentNode.insertBefore(gcse, s);
})();
</script>
<gcse:searchresults-only></gcse:searchresults-only>

</div>
</div>
``````

I would like to simply replace this with the built-in (default) WordPress search feature. The theme I am working with is custom and was created by someone else. Is there some kind of default PHP code I can replace the above script with, to use the default WordPress search instead? The theme doesn't have a template file for search, other than what is shown above.
0
I am using angularjs xeditable for one of the fields in my form.

I add shops using google maps api autocomplete. I can add as many as I want. City and country fields get updated accordingly, and also the address field, which is in xeditable format.

The problem is:

When I have multiple shops, and I want to edit the address field (which is xeditable), when I click on the xeditable field, all of the xeditable fields open up and go on edit mode.
How can I only limit it to the one clicked and not others?

<form editable-form name="myxedit">
<fieldset ng-repeat="shop in myModel.shops track by \$index">
...
<div>
<span e-name="erer" class="editable-click" ng-click="\$form.\$show()" ng-disabled="myxedit.\$waiting" e-ng-blur="\$form.\$hide()" href="#" editable-text="shop.address">
</span>
<span ng-show="myxedit.\$visible">
<button type="submit" class="btn btn-primary" ng-disabled="myxedit.\$waiting">
<span class="glyphicon glyphicon-ok"></span>
</button>
<button type="button" class="btn btn-default" ng-disabled="myxedit.\$waiting" ng-click="myxedit.\$cancel()">
<span class="glyphicon glyphicon-remove"></span>
</button>
</span>
</div>
...
</fieldset>
</form>
0