All Questions

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

hide some panel temporally in jira

Is it possible to hide the panel pointed out by red rectangle to show the panel pointed out by blue rectangle.
0
votes
0answers
20 views

Populate filter function more than once based on conditions

Bit of a weird request but I am trying to use google sheets filter function to filter data in one tab based on criteria in another. I have 2 different dishes called A & B that have the same list ...
2
votes
1answer
28 views

Array formula to show a leading zero

I have a Google Sheet where an array formula in Column I creates a video name based on the content entered into columns A+B+C+D. Column C is the number of the video. For some videos, I need a leading ...
3
votes
1answer
18 views

How to SUM LARGE 5 largest elements out of 8 numbers in a row

In Excel I am able to get the output using this formula: =SUM(LARGE(C5:L5,{1,2,3,4,5})) But in Google Sheets I am unable to get the right answer. Can anyone please help? In the image below, ...
0
votes
1answer
16 views

How to download the webpage bookmarked in the chrome browser as pdf page?

Most of the webpages keep changing or removed very often on websites.To avoid this, I would like to download them as pdfs and store them for future reference. I can do it manually. But very exhausting....
1
vote
1answer
14 views

Google Sheets Inverse (or Reverse) LOOKUP … is this possible?

As far as I can tell, all LOOKUP functions require you to know a specific search_key (like a column or row header) in order to search for and retrieve a relative value. Inversely, is there a way to ...
0
votes
0answers
30 views

Gmail's “Check mail from other accounts” has deleted mails from other account

I have a Gmail (personal) account and an Outlook (work exchange) account. I was trying to view both my accounts separately in Gmail. After the "Add an account" didn't work, I went to Gmail Settings > ...
1
vote
0answers
7 views

How do Non Blog(WordPress)/Original Content websites get approved by ad services like google ad sense?

I was interested in making a website containing image links to various important articles/videos/other websites related to a topic (say cooking). Do websites giving information about other websites/...
1
vote
0answers
5 views

How to set 9 am to 5 pm Mon-Fri on google calendar? i.e. repeat out-of-office

I know it is possible to set working hours on google calendar but I would like to have as OoO automatic replied anything beyond 9-5 from Mon-Fri.
1
vote
0answers
15 views

How to resize a table using Insert Table in draw.io?

In Draw.io perform the following: In "Search Shapes" enter "Table" use ENTER key to search. Pick the first green color scheme table by selecting, dragging and dropping on canvas. Double-click on the ...
0
votes
0answers
7 views

Firebase emailVerified variable isn't changing after clicking the confirmation email

am using firebase with ReactJS, after creating a user I am sending a confirmation email, after clicking the link, the variable emailVerified remains false no matter what I try. Here's the code where ...
-2
votes
0answers
18 views

How do I get my WordPress page to run a python script in the background that receives and returns data?

So basically, what I want to do is that after people access my WordPress page, they input a companies name and that is than given to a python script that accesses an API of another page and calculates ...
2
votes
1answer
28 views

How do I preserve the color scheme when adding a row in draw.io table?

In Draw.io perform the following: In "Search Shapes" enter "Table" use ENTER key to search. Pick the first green color scheme table by selecting, draging and droping on canvas. Double click on the ...
0
votes
1answer
4 views

Automatically move forward to what is really live on a Youtube livestream after a pause and resume

When I watch a Youtube livestream, and then I pause it, and then continue it after a while, it just continues from where it left off. So this makes me watch stuff that has happened before, and I am ...
1
vote
1answer
35 views

Limit output of array formulas to 128 characters

I have a Google Sheet where the users are building a name in a column based on content entered into previous columns. I need to limit the output of the formula to 128 characters (limitation of names ...
-1
votes
1answer
35 views

Email Message not delivered

I have sent an email from Gmail and The response from the remote server was: 553 sorry, relaying denied from your location [209.85.222.171], what can I do to solve this?
1
vote
0answers
42 views

How long does it take for Facebook to verify a new account?

I made a Facebook account for mom on April 24th and on the same day it got disabled. I used the same name, surname and birthday that is in her ID. The next day (25th of April) I saw that they were ...
2
votes
1answer
29 views

How do I increase google sheets cell number by adding 20 in a formular

I would like to use "+" or "- " in referencing a cell eg =i(10+23) = i33 . So that I don't have to increment the cell reference manually . Any help would be great ?
0
votes
0answers
8 views

¿Como puedo crear una variable JavaScript desde mi pagina web y que quede para siempre?

¿Como puedo crear una variable JavaScript y que quede para siempre? Osea desde mi web yo escribo en una caja de texto y luego aprieto un botón ¿como hago para que ese nombre que escribí en mi pagina ...
1
vote
1answer
33 views

Google Sheets Conditional Formatting based on Text and another cell

I'd like to color code a sheet based on two criteria: If the cell in the range contains specific text "A1" and if another cell, $X$7, contains an X or is not blank. I can't seem to get AND or IF or ...
1
vote
1answer
27 views

I want to 1) get unique names AND 2) strip out vacancy AND 3) alpha sort AND 4) append Last name, first name

I want to 1) get unique names AND 2) strip out vacancy AND 3) alpha sort AND 4) append Last name, first name. The names are in Sheet1 and the results are in Sheet2. I'm using =SORT(UNIQUE(Sheet1!A3:...
0
votes
0answers
6 views

Is there a way to get Google calendar to automatically number reoccurring events?

I think this may have been asked before for a slightly different purpose but I was wondering if anyone had a clearer answer. I have reoccurring appointments in Google calendar that must be counted in "...
2
votes
0answers
25 views

How to create an auto-reply to unknown senders in gmail?

I want to send automated replies to emails I receive on my gmail account, if I haven't corresponded with the sender before. This basically mimics an out-of-office / vacation reply, but only triggers ...
0
votes
0answers
27 views

Can Facebook group admins see the location of people who contact them to join their group?

I messaged a group admin requesting to join their private group and the admin was able to see my location (albeit it wasn't my actual location because I was using company server). I was using my ...
0
votes
0answers
12 views

How to set up regular “Sort range” function and formatting?

I've set up a Google Sheets template for entering data into multiple columns and rows, per individual projects. I've also created another Google Sheets "importrange" template, that's use to reproduce ...
0
votes
0answers
18 views

Want to target facebook page userid of other companies to show my ads. Is it a good practice for ABM tageting? Or we should target emails

How Facebook page userid will work if I want to target it in a custom audience. Do it target all the people who interacted with the page? Or our ads will show only upon the page(fb userid) that I have ...
1
vote
0answers
24 views

Why does my uploaded YouTube audio sound muffled?

long time lurker here in need of assistance. I created a video and it’s a montage of various videos I own. The mp4 plays fine but as soon as I upload it to YouTube one of the montage clips goes mute. ...
0
votes
0answers
7 views

Facebook owner on my fage

I have a page where I was an admin and now the page has another owner and I can't do anything, I just made an editor, how can I get my rights back on my page?
1
vote
2answers
22 views

How to write a text if conditions met in Sheets?

I want to automatically create a text depending on what the other columns shows. For example, if in A1 there is "Service", then G1='1'. And if in B1 there is "True", then G1 = "11" (as in '1' + '1'). ...
0
votes
0answers
17 views

Decrease months back when typing numbers in Google sheet

I'm trying to make a Google sheet for my savings account where my goal is to reach X money before X date and I have several fields for each month and a field to every month where I have the amount of ...
1
vote
1answer
20 views

Google Sheets graph jump by 1 on the horizontal axis

How can I change the graph’s horizontal axis to show a jump by 1 instead of 2?
1
vote
1answer
20 views

Google Sheets to Gmail Search

Basically I store order data in a google sheet. The Rows are in numerical order corresponding to the order number, is there a way to link clicking on the order number to a gmail search result? ...
0
votes
0answers
16 views

Chrome: when opening Youtube links, the video pauses after 1 sec, have to click play to continue

When I click a Youtube link in Chrome, it opens a tab with that particular Youtube link and starts playing. However, for some strange reason, after playing for about 1 second it pauses the video. I ...
1
vote
1answer
16 views

How do I format the horizontal axis labels on a Google Sheets scatter plot?

The settings for the vertical axis on a Google Sheets scatter plot provide an option for selecting or customizing a format for the labels, but no corresponding option is provided for the horizontal ...
-1
votes
0answers
5 views

How do you place tiles in Scrabble Go?

In Scrabble Go on Facebook, how do I put a tile down onto a square? I can drag the letters but I can't release it. I access Facebook through Firefox on a Windows 10 desktop.
1
vote
0answers
10 views

In a large document with many comments how do you review everything, both open and resolved comments, page by page?

The 'Comments' button allows me to see the comments in date order but that doesn't give me the context of the page it was on. I have no idea when some of the comments where made, that I am looking for,...
1
vote
0answers
22 views

Why can’t I see a full list of people who liked my Facebook post?

I have a post with 6.9 thousand likes and I'm trying to invite them all to like my page, but it stops showing the rest of the list once I get about 700 people down. I can't scroll down any further, ...
0
votes
1answer
20 views

Have a new Google form be started linked to an existing spreadsheet

My problem: I want to create a new form and have it automatically linked to an existing spreadsheet. It can create a new sheet on the existing spreadsheet, but the linking step should be automatic. ...
0
votes
0answers
7 views

Google calendar notes mangled in iPhone view

If I cut and paste from a google spreadsheet into the note section on an event on Google Calender I can do this: PS 5 G10 PP 1 T7 SC 10 G10 ApKerr 1 G10 ...
1
vote
0answers
16 views

Multiple hyperlinks in a single cell in Google Sheets [duplicate]

I'd like to use HYPERLINK to add multiple links to a cell, like this: ="Click "&HYPERLINK("google.com","here")&" or "&HYPERLINK("bing.com","here")&"." But the above code merely ...
0
votes
0answers
34 views

Gmail deleting email then logging again mail is still there

It has happened multiple times now to me: I log in delete some new mails, log out and when login again, mails are still there.. what is wrong with Gmail?!
1
vote
0answers
14 views

In Google Sheet : How to split an amount between specific cell value?

My problem is: I order beers. Beers can sometimes comes by 24, 12, 4 or 1. I am trying to find a way to easily divide an amount to specific cell value and have in a cell the remainder if there is one. ...
1
vote
1answer
24 views

Array formula with concantenate not working

I have a Google Sheet where I am wanting to use an array formula so it auto copies down the column rather than the current formula which needs to be copied down manually. =(IF($E2="Yes", $D2, ...
1
vote
1answer
14 views

How to show unique values from a column in a pie chart?

I am trying to get unique values of the "Sector" column and display them on a pie chart. For example for investments, the pie chart should be able to display investments along with the sum of all the ...
0
votes
0answers
19 views

Facebook Messenger Active Status Missing

My facebook/messenger active status is missing even though I haven't turned the active status off. Whenever I became idle or offline, my status is missing and it doesn't the active xx ago. Any ...
0
votes
1answer
17 views

Google Query: filter one record per day/week per user

I'm collecting repeated measures using Google Forms which only allows 1 or unlimited responses. I need a way to filter out responses that were entered by the same user too near to each other. For ...
0
votes
0answers
82 views

How to retrieve files being held hostage by OneDrive?

I've recently encountered a very frustrating issue where all of my friend's important documents were on OneDrive when he had a compromised Microsoft account. I called many Microsoft numbers to reset ...
1
vote
0answers
8 views

Extract slide titles from google slides presentation to create a table of contents

I need to extract all slide titles from a 100 slide presentation to create a table of contents google document. All the slides follow a strict template so the titles are more or less uniform ...
2
votes
1answer
16 views

Import specific rows and formulas from master sheet

I have been looking for hours now how to solve my problem, as it follows : I want to duplicate this master sheet a hundred times and be able to let the end-users fill in the green cells, without ...
1
vote
1answer
11 views

Bar chart that counts rows google sheets / Pandemic-like chart

I have a google form linked to a google sheet (so every time somenone fills the form, a new row is created). I would like to make a chart that count the number of rows each day. In the example shown ...

15 30 50 per page
1
3 4
5
6 7
605