All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
32 views

“IF” Functionality Inquiry

So I am trying to figure out how to whenever it's a "Y" and "INCOMING", then it will equal a dollar amount. So as if a + b = 1 then equals $35 =COUNTIFS(F3:F100,"Y",B3:B100, "INCOMING") I did it a ...
3
votes
1answer
39 views

Hold position relative to content in a rapidly changing Google Docs document with many editors

I'm trying to edit a big Google Doc with many editors all typing at once. When people above me type and add or remove text, the document reflows, and the part I am trying to edit moves from page to ...
3
votes
4answers
4k views

Import current price from website to spreadsheet

As you can probably gather from the title, the goal is to plug the current price of this product into a spreadsheet. Perhaps I'm over-complicating things, but there must be an easy way to do this. ...
3
votes
2answers
6k views

How can I get GoogleFinance to see 1 year and 5 year return of a stock?

You can use GOOGLEFINANCE("name", "return52") for mutual funds, but not for stocks. Is there another way to get the same result?
0
votes
0answers
9 views

How do I search for an exact multiple-word string in Bitbucket?

I want to search Bitbucket for public T get in this exact order. Any words can be before public or after get but the complete phrase public T get should match. But when I search using double quotes ...
14
votes
6answers
14k views

How to remove a label from a card in Trello

I don't see how to remove a label from a card. A work-around is if I define one of the six available to mean "no label", but that leaves a meaningless color and reduces to only 5 useful colors.
0
votes
1answer
5 views

How to replace data from one column into a placeholder in another

Some thing that does this: I'm thinking in Google Sheets have column A be let's say City, and column B be let's say address, then I want to paste something into column C like: "Are you looking ...
15
votes
1answer
29k views

Is there any way to force subtitles in a YouTube video?

I uploaded a video in French on YouTube but a non-negligible number of English-speaking people are going to watch it. I uploaded the .srt file and everything works fine when I press the "CC" button. ...
27
votes
6answers
93k views

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "...
0
votes
0answers
4 views

How to rename a series in Google Sheets chart?

By default, a Google Sheets chart will use the first row as the the name of the Series. But if you are selecting a range in the middle of the table (for example, rows 38-100), then you can't use the ...
0
votes
0answers
50 views

Add corresponding numbers if checkboxes are checked

I am working on a spreadsheet that has check boxes. How can I compute the sum of lines where the checkboxes are checked? So far I have this but need it to count all of the corresponding numbers from ...
0
votes
2answers
3k views

Is there a way to record Google Meet live captions

Google Meet (web, in particular) has live captions Is there any way to record (and save) this [whole/full] meeting transcript?
5
votes
4answers
10k views

Google Docs thumbnails do not update, can I force an update?

I am working with Google Docs. I make copies of existing documents using the option File - Make a copy.... The document gets copied and I work on the copy and change the copy. When I close it and ...
2
votes
3answers
2k views

Turn off snap-to in Google Drawings

How do I turn off "snap-to" in Google Drawings? I have a ton of shapes with snapped lines to other shapes, and every time I need to rearrange shapes or drag a line elsewhere or want a line to end at ...
1
vote
2answers
2k views

How to undo strikethrough on Google documents

How do I undo strikethrough on a whole page with table layout? I have tried Command key + Shift + X and it does not work.
0
votes
1answer
5 views

Is there any way for my attached file to be above the signature?

Like the title. I just wanted to ask how to get the attachment above the signature. I couldn't find any thing about this
-1
votes
1answer
7 views

Web Animation technologies

Nice to be here. Can anyone tell me what kind of animation technology was used on the adguard site I tried to sift through the code but could not find a hint. thanks a lot!
0
votes
1answer
25 views

How To Edit Title Caption?

I am unable to edit a title caption on photos I posted in Google Shared Photos. Is there a way to edit the title caption?
0
votes
1answer
3k views

How can I checkout part of my cart on aliexpress?

If I have 10 items in my cart, and I just want to buy 5 right now, is there an easy way to do that? From what I've seen, I can choose to pay for a specific seller, but not multiple (as long as it's ...
0
votes
1answer
10 views

Recurring event every x hours in Google Calendar?

I need to create an hour-long event in Google Calendar that repeats every 124 hours, but there is only an option to repeat days. I did some research, and it might be possible with some spreadsheet ...
0
votes
0answers
5 views

How to disable a shortcut of the Wikipedia?

I use a shortcut for quick searching for the selected text on webpages by the search engine. However, when I invoke the shortcut at a page of Wikipedia, I find my shortcut is conflicting with the ...
0
votes
1answer
10 views

Is it possible to highlight the minimum value in a table on Gsheets?

I am currently compiling a table of pace per minute on this Gsheet. I am looking to conditionally format the cells to highlight the minimum and maximum but cannot seem to find a formula for this ...
0
votes
1answer
3k views

Google Sheets Conditional Formatting Isn't Working

I am making a spreadsheet in Google Sheets and my conditional formatting works in some cells and not in others. I have gone so far as to delete all of the formattings for the entire workbook and ...
1
vote
1answer
8 views

get value left of max value

I have a sheet that looks like: Date Value Highest Lowest ---------------------------------------------------------------- 1-1-2020 23 26 20 2-1-2020 20 3-...
0
votes
0answers
13 views

Recover Facebook account, without access to email and

We have the following scenario: Alice is authenticated on Facebook on her phone. She forgot the password of her Facebook account Can't access the email associated with the Facebook account and does ...
1
vote
2answers
2k views

If I like a friend's old post, would my 'Like' appear to our friend's (mutual) news feed?

If I like a friend's really old post (2011 - something he posted to me - it actually appeared to me on my "ON THIS DAY" section) would my 'Like' appear on our mutual friend's news feed? I don't want ...
0
votes
0answers
5 views

cannot run a video party in a community page

I have two similar pages, I've created them as community pages. I'm publishing live videos on both pages, and when I finish the live session I share them in their respective pages. On the first page,...
0
votes
1answer
63 views

Google sheets join arrays

What I'm trying to do is to join few arrays of dates. For start, I have start date and amount of months I want to generate. Which I did by using =ARRAYFORMULA(DATE(YEAR(A2), MONTH(A2) + SEQUENCE(C2, ...
1
vote
2answers
1k views

Conditional Formatting based on other column

I have a timesheet log with columns DATE | HOURS | DESCRIPTION OF WORK | PROJECT An employee may enter several rows for the same date to log the different amount of time with respect to the ...
-1
votes
0answers
5 views

TypeError: cannot pickle '_thread._local' objectI am trying to run following code

I have made a register route and function which will add new users to the database. The code is working fine, messages are flashed according to the condition, but the only problem is that when I try ...
4
votes
1answer
2k views

Programmatically create an internal hyperlink

I need to programmatically create a large number of links in a Google Sheets that point to a specific range in another sheet of the same document. I tried to use named ranges for that but for the ...
-1
votes
0answers
8 views

Access to my gmail via my laptop

Tried to load zoom on my laptop ( which was unsuccesful for some reason ) now I have the following problem. I can access my gmail via my android phone but not my laptop. Through outlook I keep getting ...
0
votes
1answer
5 views

Decompose a column into multiple columns with TRUE/FALSE values instead

Here is a very small version of what I want to achieve but not able to figure out what exactly should I Google search for - Column A | Column B Alice | Present Bob | Absent Should ...
3
votes
1answer
7k views

Show all posts and comments in a Facebook group that I am a member of, not an admin

I am a member of a group and I would like to see all the posts and comments from the beginning of the group (approx 8 months ago). Is there a way that I can do this without spending hours simply ...
1
vote
1answer
141 views

Search for a range of numbers in the title on Google News

I'm trying to find a range of numbers inside of titles in Google News. I tried something like intitle:4..25 but it only found results for which the exact string 425 appeared. Any ideas?
0
votes
0answers
6 views

I want to change my google account in my mobile phone which is not mine. How can i do that without knowing the password

i am having a serious problem with my Google account in my mobile phone. My phone was used by another person earlier that's the reason why my mobile phone's google account is not my own. ...
0
votes
0answers
89 views

Can I change the email for my steam account without logging in?

I made a Smurf account a while back and forgot my email. Now I can't log in because I forgot the Username/password and email. So is there anything I can do to get it back? I have the account as a ...
1
vote
2answers
45 views

When any username on a sheet matches a username on another sheet, copy over certain values into specific columns

I have a sheet with current users of a system (only by username) and I have another sheet that is a master list of username associated with employee first name, last name, and employment status. What ...
0
votes
1answer
11 views

Prevent a Google Script from Modifying Date

I have a Google Sheet that I am applying an onEdit script to. That script (borrowed from here) capitalizes all new entries in every field of all ranges of all sheets. function onEdit(e) { if (...
0
votes
1answer
20 views

Custom Formula Conditional Formatting in Google sheets, referencing to different sheet

I wanted to format a cell based on another cell values in another sheet, this formula works but only on the certain cell it was input first: OR(indirect("2019!U18")="MIS",indirect("2019!u18")="...
2
votes
1answer
35 views

Review results field

I want to post on the form a field that and only a Editors permission user can modify and a none permission user can see, for example the result of a evaluation of a specific document uploaded.
4
votes
3answers
9k views

How to reverse the y-axis in a Google Sheets graph?

I have data that represents the depth of an open mine in a transversal view. Currently, it looks like this: But since it represents the depth of a mine, I'd rather have it "flipped". So the y-axis, ...
0
votes
1answer
3k views

How to insert Mathematical Equations in Google Sheets?

I have been searching for a while now and all searches lead to Google Docs, not Google Sheets. So basically what I'm looking for is similar to the insert equation function as in Excel where you can ...
0
votes
1answer
2k views

Gmail doesn't show entire message

I have a large email message, and whether I am on Desktop/Laptop or Android app, clicking the Show Entire Message link only opens a new tab which either prompts me to sign-in to Gmail or takes me back ...
0
votes
1answer
411 views

QUERY remove column and column header if blank

The attached document is a time-sheet document. There are 2 tabs, TimesheetData and InvoiceData. I want to pull through data from TimesheetData tab to the InvoiceData tab using a query. The query I ...
0
votes
0answers
4 views

Comments not being sent on Facebook Messenger along with the posts I'm forwarding

When I send a Facebook post to someone through Facebook Messenger, the comment I write with it never goes through, only the post. Where could the problem be coming from?
1
vote
1answer
21 views

Google Sheets time sorting chart

I have a MailChimp data export in google sheets and I want to create some charts that can show the best time of day/day of the week based on my data for our mail outs when compared to open rate (%). I ...
0
votes
0answers
5 views

How to run pyodide on my Gitub-pages website?

I have a GitHub pages website on which I'd like to run commands from SciPy. The user will input three values (A, B, C), and a python code will find the optimal nontrivial values: X, Y, Z such that X^A+...
0
votes
0answers
7 views

Please Help Me Find My Twitter Account

I used my phone number for 2 or 3 more accounts on twitter and now i really want to find those accounts but i forgot the usernames
0
votes
1answer
33 views

Whats the reason that instagram doesn't allow direct messages from the web browser?

Whats the reason that instagram doesn't allow direct messages from the web browser from a PC? I guess for a company like facebook it would be no technical problem to implement this, so there seem to ...

15 30 50 per page
1
2 3 4 5
595