All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
10 views

How do I simplify this formula to be expandable?

The Example sheet The formula: For all x from 1 to 10, if (Sell <= Buy * x) then x, else ">=10" I thought I might be able to cheat a little with the sequence function: =ARRAYFORMULA(...
user avatar
  • 1
0 votes
0 answers
4 views

Restore Tabs from a Specific Time [closed]

Is there any way to restore my tabs from a specific time yesterday (e.g. 10 pm) on Chrome and Microsoft edge?
user avatar
0 votes
0 answers
12 views

Have a cell go blank when the date in the cell is reached in google sheets

I would like to be able to put a future date in cells f4-f12 and when the date is reached that cell goes blank. I have a filter function on there now looking for a blank cell thanks in advanced. Kevin
user avatar
0 votes
1 answer
7 views

Google Chrome passwords suddenly disappeared how to fix?

All my saved passwords suddenly disappeared from passwords.google.com how to fix. Sorry if this is off topic super urgent though.
user avatar
  • 103
3 votes
1 answer
44 views

Formula for matrix

Firstly, apologies for this question but I couldn't really wrap my head on how to do this (ultimate aim is to put it in app scripts) Let's say I have a table that is updated daily showing the fruit ...
user avatar
  • 145
0 votes
0 answers
17 views

Google sheets: Single out certain words in string based on second string

I have one column with concatenated words, say international city names. Each cell in this column is different, but city names overlap. And I have one cell with concatenated words, say only German ...
user avatar
  • 1
0 votes
0 answers
2 views

How to delete entire group chat in messenger?

Accidentally added someone to a private group chat. How can I delete the entire conversation so they won't see it?
user avatar
  • 1
0 votes
0 answers
16 views

How to edit/format/change date forat sequence of a existing data into another date format sequence?

I got a bank account statement xls sheet with date in format of DD/MM/YYYY i.e. 06/01/2019 in the original form, but when I'm trying to format it into DD-MON-YY it is taking the value as MM/DD/YYYY ...
user avatar
0 votes
0 answers
8 views

Can I see a user's previous comments on a certain youtube channel?

Afaik: When using the youtube app: I can go to a youtube video, scroll down to comments and then tap on a person's profile picture to see the recent comments they've made on the channel plus the ...
user avatar
  • 201
0 votes
0 answers
2 views

My Facebook page has no invite option

I am facing a problem for a few days and tried my best to get it out but couldn't. The problem is that the Page of my site has no more invite options. Before it was available and I also sent ...
user avatar
  • 1
1 vote
2 answers
28 views

Cell specifying the running total length

Context Here column C contains a running total of the last 5 items from column B. Formula The formula is straightforward: Question In the above, it's hardcoded for a running total of 5. What's a ...
user avatar
0 votes
0 answers
7 views

how to sum a column of variable length, starting at the first cell below the nearest blank cell

Can anybody help with this please? I need to sum a column of figures. The number of rows in the column will be variable, but will be a contiguous range, with no gaps. The range for the sum will start ...
user avatar
0 votes
0 answers
9 views

Facebook login issue

Someone else used my Facebook number to create a new facebook account and I can't get login into my Facebook account because I forgot my password. And I've tried to recover my lost password but it ...
user avatar
  • 1
0 votes
0 answers
4 views

Google Meet revokes my ownership of meeting when I assign to company calendar

I'm trying to set up a Google Meeting. Everyone in the company has a calendar that is "owned" by a company GMail account that was set up long before we got Google Workspace, so I create ...
user avatar
  • 448
0 votes
0 answers
15 views

How do I make a points system on Google sheets?

I have a timetable where people can write their names into a box which correlates to a different duty they must complete I want to assign a different value of “points” to each duty so that when a ...
user avatar
0 votes
1 answer
22 views

How do I keep exact text formatting when using a data validation dropdown list in Google Sheets?

I have a column that contains a bold number and a non-bold text part. I want to use this information as a drop-down selection list, but it currently isn't letting me keep the bold formatting on only ...
user avatar
0 votes
3 answers
20 views

Making a graph from data of one out every n lines

I have data that comes in batches of N values ("Y" values if you like) for a given index (or "X" value if you like). How to make N separate series in my graph for each entry of a ...
user avatar
  • 101
0 votes
0 answers
4 views

Emails vanished from inbox [duplicate]

Suddenly all emails vanished from my inbox from last week to April 2021. Can see them in all mail but how do I get them back into my inbox
user avatar
0 votes
0 answers
6 views

Gmail deliveredto operator not working for email alias addresses in Google Workspace

I am using Gmail on Google Workspace and I have multiple aliases setup on my root Gmail account (e.g. myusername@domain.com) such as: webmaster@mydomain.com admin@mydomian.com privacy@mydomain.com ...
user avatar
0 votes
0 answers
8 views

Free tile map servers for OpenStreetMap similar to openweathermap.org but for non-weather data?

https://openweathermap.org/api/weather-map-2 shows openweathermap has a free (limited, API key required) service that lets you pull maps in "slippy tile" format so they can be overlaid ...
user avatar
0 votes
0 answers
6 views

How can I see all my public events on my Google calendar?

Events on a Google Calendar calendar may be public or private. How can I see all my public events on my Google Calendar calendar?
user avatar
0 votes
0 answers
9 views

Uncaught ReferenceError: Token is not defined [closed]

I'm following this tutorial - https://www.youtube.com/watch?v=XdKv5uwEk5A&list=PLS5SEs8ZftgWFuKg2wbm_0GLV0Tiy1R-n. After using the command truffle migrate --reset the blocks appear on Ganache GUI. ...
user avatar
0 votes
0 answers
9 views

Blender insert vertices into a face

I am trying to insert a complex vertices structure into a face without disturbing the structure. See pictures what i need:
user avatar
1 vote
2 answers
22 views

Is setting a trigger for a function to run with a triggered function not allowed?

I would like my function freezeSunday to run at exactly at 1pm on Sunday. Since it does not appear that you can trigger a function to run at a precise time (only at a randomly selected time within a ...
user avatar
0 votes
0 answers
12 views

Google Sheets Margins in Print Settings Significantly Different than Printed PDF

I need to generate a PDF from a sheet in Google Sheets and I need the margins to be exactly as depicted in the print settings preview. As you can see in the picture below, the preview is differing ...
user avatar
0 votes
1 answer
27 views

How do I put the if function inside the lookup? - Daily Routine sheet

I have a sheet - daily routine which has two columns: activity and time as shown here Activity Time Sleep 😴 6:00 am Toilet 🚽 6:15 am Get ready for gym 🤸‍♂️ 6:30 am Exercise 💪 7:50 am ... ...
user avatar
  • 101
0 votes
0 answers
13 views

Insert Dropdown (Cell Range) from Google Sheets into Google Doc

I'm using Google Docs to collect a lot of information about property. Each property has its own Doc file. In this Doc, I have various Dropdown lists. I'm at the point where I need to update and add ...
user avatar
  • 101
0 votes
1 answer
15 views

Google Sheets - Is there a way to filter values but keep them in the respective rows they came from?

I'm looking for a way to filter values based on another column but keep them in the same rows they came from. Here's an example I created manually of the correct output: The goal here is to have a ...
user avatar
1 vote
2 answers
26 views

Google sheet, from 2 lists to flattened table

I have two independent columns with data. How could I use that data to then produce a flattened table like this:
user avatar
  • 113
1 vote
2 answers
28 views

Google sheets function to filter out lowest associated cells

I was wondering if there's a way to use a function (maybe Filter?) in order to sort this data such that column K only contains one of each number, and the highest test associated with it in column L. ...
user avatar
0 votes
0 answers
6 views

Structuring a database for an investment portfolio? [closed]

would really appreciate some general advice on the structure of an app i'm building. I'm essentially trying to re-create an investment portfolio app using a MERN stack. Something very similar to ...
user avatar
0 votes
0 answers
16 views

How to approach this? Which formula should I use?

I am working on a Google Sheet in which I am classifying a "product" with an id number and I want to pull out data from another sheet that contains 2 things: confirmation of the id type of ...
user avatar
0 votes
1 answer
24 views

How to write a Google Sheets formula to extra a substring from a URL?

I'm trying to set up a formula to extract data from a URL that is in one of the column B of my Google Sheet. I've been tryin use the LEFT formula to extract the data, but the problem is that the ...
user avatar
2 votes
1 answer
66 views

"Copy to" confusion

In my spread sheet, there are 3 tabs, let's call them A,B and C. Tab A has user input data Tab B picks up that data (get.range and set.formula) and time stamps it (daily interval) with rows appended (...
user avatar
  • 145
0 votes
1 answer
18 views

Very strange YouTube upload issue

It's been a couple of weeks that I'm facing a very strange networking issue: I am trying to upload a video to YouTube. Any video. I am using YouTube's web interface on the browser. Any browser (I ...
user avatar
  • 1
1 vote
0 answers
6 views

Google workspace Add-on with associated server: managing OAuth and permissions [migrated]

I am working on a project I inherited that adds some functionality to Google Docs through a workspace add-on written in gscript. The add-on makes API requests to a standalone web application. The web ...
user avatar
  • 11
1 vote
0 answers
21 views

Filter date, and add blank rows between different time slots

I'm trying to build a reservations spreadsheet for my friend's restaurant where she can input on monthly sheets as resos come in, then see a filtered, sorted summary of any selected day. Here is a ...
user avatar
  • 11
0 votes
1 answer
6 views

How to know when a page was (first) indexed by Google?

I see that Google has already indexed a page. However, I cannot find when Google indexed a page. How to know when a page was (first) indexed by Google?
user avatar
  • 101
0 votes
0 answers
8 views

Search only headers and/or only in outline of Google Docs

I have a Google Doc with a large outline to move through the doc: If you have more than 100 headers, it is hard to find a header with a word like "mysql" if that word pops up every now and ...
user avatar
0 votes
0 answers
4 views

MULTIPLE Ifs and concatenate problem

I'm trying to create some "if" scenarios and include concatenate to create unique serial numbers for reports. Example: IF someone chooses "IT" from the dropdown menu in cell I4, I ...
user avatar
0 votes
0 answers
5 views

Pages visited in Facebook appears even after deleting activity log in iOS. How to delete them permanently?

I have deleted my activity log. But still, the pages I visited can be retrieved by clicking on Pages or "posts you've seen". How to delete them permanently?
user avatar
  • 1
0 votes
1 answer
14 views

Trying to change Gantt chart in Google Sheets to highlight a cell based on date range and progress percentage

I have been working on a dynamic Gantt chart template in Google Sheets for awhile now. Here's how it currently looks: As you can see, the task bar currently highlights gray dependent on the start and ...
user avatar
-1 votes
0 answers
5 views

I think someone might be hacking my iPhone

Recently I found out that my laptop was hacked into I removed and reset my entire computer changed all my passwords but before that I had my phone plugged in and it was used for transferring some ...
user avatar
0 votes
0 answers
3 views

How to set-up email archiving/journaling for all users on Outlook 365 e-mail?

How to set-up email archiving on Outlook 365 e-mail on a custom domain? I don't mean Godaddy 365 emails. This would let one search all-emails on the account.
user avatar
  • 101
1 vote
1 answer
30 views

Text input if cell > than 1

I would only like the values in Column A to return if there is a value of >1 in Column B - I am unsure on a formula to do this
user avatar
0 votes
1 answer
12 views

Google sheets indirect formula question

I have a list of students that in Column A has their first name and then in following columns has their specific data that I am interested in. I have removed last names and data as it is sensitive ...
user avatar
  • 1
1 vote
1 answer
47 views

Appscript: Compare a cell Value pre & post update to populate another cell

Newbie to scripts. Link to the sheet with minimal essential information In the status tab, there would be an inventory of equipment (currently only one (A1). The equipment can be in various states (...
user avatar
  • 145
0 votes
0 answers
15 views

Google Sheet Crashing Error Code: Out of Memory or RESULT_CODE_HUNG

I'm a documentation manager and have a Google Sheet that serves as the primary tracker of my team's active pipeline of documents. The file is quite large and includes a lot of formulas and scripts to ...
user avatar
0 votes
0 answers
5 views

How to copy and paste a cell format in iCloud Numbers

In iCloud Numbers, how do I copy and paste a cell's format only? There seems to be an answer for this in the forums, but it refers to a menu available on the desktop application, which I cannot find ...
user avatar
  • 101
0 votes
0 answers
8 views

Does Google Maps "Timeline" require a SIM card?

I recently got an iPhone 8, which I'm using without a SIM card (i.e. not as a phone). Google Maps says that I have Timeline enabled, but each day shows no activity. Is that simply because of the ...
user avatar

15 30 50 per page
1
2 3 4 5
658