All Questions

Filter by
Sorted by
Tagged with
-1
votes
0answers
5 views

Why are my Facebook photos losing quality?

The pictures on my Facebook account seem to have become more pixelated. I compared a photo with an old screenshot on Online Image Diff, and there really are differences. How could I get my original ...
0
votes
1answer
6 views

Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data

The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
0
votes
1answer
4 views

Odd ProtonMail text modification in drafts

I have a text stored in ProtonMail's draft message. Once, I logon and I see odd modifications to my message: seems like < has been changed to &lt;. seems like > has been changed to &gt;...
0
votes
0answers
4 views

update other sheet's rows based on pasted data

i have a worksheet with several sheets in it for social media analytics purposes. i would like to be able to paste data from a csv i export daily into one sheet and have the data parsed and copied to ...
0
votes
1answer
12 views

How can one recover a locked Facebook without asking one's friends for help?

I logged into Facebook from a different country where I am typically located: the account got locked. It seems that one can unlock the account with different ways but as shown in the example below, it ...
0
votes
0answers
4 views

How can I send an email, with an attachment from the user's local storage, using Google Sheets Script?

I'm new to Google Script but quite experienced in Excel VBA. I'm trying to set up a Google Sheet to enable sending of a given document by email attachment to a number of recipients. I've got the email ...
0
votes
0answers
5 views

Copy the data from one sheet to another, assigned to a particular line

I have two google sheets. I need to copy the data from one sheet to another, assigned to a particular line. For the sake of ease of understanding, I changed the colors in the sheets example as they ...
0
votes
0answers
5 views

Google Sheets pull data from second sheet where Row and Column are strings

I am trying to pull data from a different sheet in google sheets by matching row and column header EG SheetB LOC prox dist qty sjc 12 15 19 dfw 10 16 8 atl ord In ...
-1
votes
0answers
7 views

My currency not available [on hold]

I am from Maldives. My currency is MVR (Maldivian Rufiya) but it is not available in currency options when i tried to add products in my page. Is there any solution for this
0
votes
1answer
9 views

Countifs in between ranges

I'm struggling to pull below conditions together. I'd like to have a formula that will count values between 1 and 5 only when cell U13 contains the text 1-5. =COUNTIFS(U13,"1-5") =COUNTIFS(K2:K22,"&...
0
votes
0answers
4 views

How to disable pinning every message when forwarded from the channel?

I've linked the super group under Discussion Group section of the channel, so everything that is posted on the channel is being forwarded to the group. However, as the side effect, all messages are ...
0
votes
1answer
12 views

I want to get values from multiple URL's in Google Spreadsheet. IMPORTDATA doesnt work

I have 9000 lines with URL's in my Google Sheet. Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10). Every URL returns JSON like this: { "success": ...
0
votes
1answer
15 views

How to partial extract from 3 columns with multiple levels of rules?

The formula someone on this forum provided worked well, but I have run into a problem, which I am struggling to get around. Google sheets Link The formula in H2 looks between 00 & 02 and ...
-2
votes
0answers
5 views

Which is the best/most used web UI builder? [on hold]

I would like to know what UI tool is used by most web developers - or you tinker with the CSS until the outcome is just right? I have a hard time creating the UI and it still looks ugly, even on my ...
-1
votes
0answers
13 views

How do I set the price information of my Facebook Marketplace listing to be 'Contact Seller'?

When I tried to post a listing to Facebook Marketplace, it seems that the price field of the form only allows numbers, and will disable the 'post' button if I did not enter a number. This is also the ...
0
votes
1answer
16 views

Google sheets spreadsheet will not format date correctly

I have a Google spreadsheet with a date column formatted to dd mmm yyyy. Many of the dates are formatted this way, but some cells will not format this way, and no matter what I select under "Format", "...
0
votes
0answers
6 views

Why do pictures of my Leaf dash display get tagged in Budapest

I take pictures of my Leaf dashboard display to monitor my miles-per-KWH. I recently uploaded to Google Photos all photos from my iPhone SE (running IOS 12.3.1). The Leaf display photos have been ...
0
votes
0answers
6 views

hide rows in Google Sheets based on cell value in a different row

I'm trying to build a worksheet in google sheets with a checkbox which will hide and unhide lines 5 thru 60. My checkbox is in cell A4, and when checked cell A4 says "hide", and unchecked cell A4 ...
0
votes
0answers
23 views

I hit the select button and all my emails disappeared. How do I retrieve them or where are they?

I hit the select button by accident and then all my emails disappeared. How do I retrieve them or where did they go?
1
vote
1answer
31 views

ArrayFormula to extract part of the string

I have come across the below formula, and I am finding it quite useful, I want to turn it into an array shortly, but before I do, I was wondering if there was an easier way to do this? =if(len(LEFT(...
1
vote
1answer
16 views

When I insert a row, indirect does not update

I have a summary sheet and I would like that every time I add a new sheet everything gets referenced to the summary sheet. I have used indirect to do this, the only flaw is that once I add a row, the ...
0
votes
0answers
6 views

Undo “post and always allow future posts”

I accidentally clicked the post and always allow future messages from author, can I undo that?
0
votes
1answer
6 views

Simplify fractional result of custom number format

In Google Sheets, I created a custom number format like this # ??/32 to express decimal numbers to the nearest 32nd fraction. So if I type 0.537 I get 17/32, but if I type 0.5 how do I get it to ...
0
votes
1answer
13 views

Unsimplified Fractions in Google Sheets

How can I get Google Sheets to display fractions in the form I enter them, rather than in a simplified form? I'm trying to evaluate how a student did on a test, so I have one cell that reports the ...
0
votes
2answers
8 views

How to archive cell changes in new tab?

I have a Google sheet that I'm collecting some statistics in. There is a particular cell that I'd like to track changes in a separate tab. I'm looking for a function to copy cell if the cell data ...
-1
votes
0answers
33 views

How do I delete a Gmail account associated with my Hotmail account so I can make a new account?

I have delete the account, but every time I log into Gmail with my Hotmail account, it brings in the deleted account. I do not use this Gmail account. I want it deleted so I can make a NEW Gmail ...
-1
votes
0answers
5 views

Make list from different sheet dependent on answer [on hold]

I want to make a list from a different sheet dependent on answer from google form. For example, if mom registers her son for FB, his name will go from the master list to Sheet 2 titled "Football"
0
votes
0answers
13 views

Complicated Google Sheets Project [on hold]

I am a teacher and am designing a tool to help teachers design units and plan lessons. I am new to coding and this is becoming a bit ambitious for me. I am happy with what I have so far but there are ...
0
votes
2answers
15 views

Help with a Vlookup function to return multiple results of not exact match

I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are ...
1
vote
2answers
28 views

Combining IMPORTRANGE, SUMIFS, QUERY with cells that contain numbers and text

I'm having an issue combining SUMIFS with ImportRange in Google Sheets. I found answers suggesting to nest it with QUERY. However, the issue is that one of my criteria is non-numerical. Formula in ...
0
votes
0answers
9 views

In Trello, is there a way I can see all cards assigned to me within a specific team and then assign them an order?

I'm a member of Trello team where boards correspond to individual projects, each list under a project corresponds to a type of task. (e.g. bugs, features, etc.), and each card is an individual task. ...
-1
votes
0answers
9 views

What if both person on messenger shows active “1 minute ago”and “active now”at the same time and it happens more than 10 times [on hold]

What if both person on messenger shows active "1 minute ago"and "active now"at the same time and it happens more than 10 times.
0
votes
0answers
7 views

Slack indicates unread messages in the tray icon even when set to only notify for mentions

I'm in a couple pseudo-public workspaces on Slack that have quite a bit of activity. I've gone into my settings for these workspaces and all the channels in them to make sure that I should only be ...
0
votes
0answers
34 views

How Can I Ignore Null Cells in a Google Sheets Chart?

I'm generating a chart where I have to have some empty cells due to the way my data is formatted. However, I cannot figure out how to ignore those empty cells when generating a line chart. I've tried ...
-2
votes
0answers
14 views

Build a document viewer like amazon look inside [on hold]

i need to build a document viewer like the Amazon "Look inside". How can i build that? With Html/css or do you know any free frameworks? I couldn't found anything. Thanks in advance!
-2
votes
0answers
8 views

Is there an Email limit? [on hold]

Is there a limit on how many people you can email at a time if they are in a group? I have two groups that I email regularly, (104 & 95 members), but some folks do not receive the emails. Help!
0
votes
0answers
8 views

conditional formatting skipping colors after the same large value

Looks like the conditional formatting skipping large formula because of the same large values. Help me please how can I get the order what is on the picture in the column "What I would like".
-2
votes
0answers
10 views

Same email for two people? [on hold]

Constant receiving junk email clearly aimed at someone in Australia plus I recently looked on Amazon and was directed to my recent browsing history to be shown a selection of games and computer ...
0
votes
0answers
14 views

Tumblr pages no longer redirect - How to redirect using pages on a Tumblr blog

It used to be that you could create Tumblr pages to redirect to posts or other non-Tumblr URLs. For example, you could create a page pets and redirect it to a post on your blog (using the post's ...
0
votes
1answer
14 views

Google sheets IF OR script

So this is the code that I'm using for the script that I found; function onOpen() { var s = SpreadsheetApp.getActive().getSheetByName('Todo'); s.showRows(1, s.getMaxRows()); s.getRange('D:D') ...
1
vote
1answer
6 views

Sort GitHub issues by title

It doesn't look like sort:title or sort:title-asc works Does anyone know of a way to sort within the tool?
1
vote
0answers
17 views

Is it possible to create a share link to a specific location in a Word Online document?

I would like to be able to send a link to a colleague, which will take him to a specific location in the document when the document opens in the Word Online web application. For example, a programmer ...
0
votes
1answer
9 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
1
vote
1answer
30 views

Simplify multiple OR statements in a QUERY using IMPORTRANGE

I am trying to query values from a different sheet using a range from the current sheet. Is there a way to simplify the formula and get rid of all the ORs? Like maybe using a FOR loop? =QUERY(...
1
vote
0answers
7 views

Conditional Formatting formula for alternating checkerboard with Merged Cells?

I wrote a formula that attempts to create a checkerboard pattern via conditional formatting, that should even work with Merged Cells. However, it seems to fail in an almost undebuggable manner with ...
1
vote
1answer
11 views

How to reference a local cell in QUERY?

I just about have formula 100% perfect. Just one issue: Formula (Works): =QUERY( ImportRange( "https://docs.google.com/spreadsheets/d/1Lf4r_b0fmFh6fClZsGmfZmo8ZD87qf8N_0f-Jaoyu-g/edit#gid=0", "...
0
votes
1answer
16 views

Google Maps grey dotted lines identified location

I clicked to search for directions on a place on Google and it redirected to Maps. Google was able to precisely identify my location The map displayed several thick grey dotted curves all converging ...
-1
votes
0answers
5 views

Google Form Drop-Down List questions based on previous drop-down list select

The majority of questions that I have found regarding Google Forms referencing the drop-down listing based upon another drop-down list selection (cascading), is directed to the Google sheets, or it is ...
0
votes
0answers
18 views

Excel Online can't see other people's selections

I found this on microsoft's website: Why can’t I see other people’s selections? You can see other people's selections in different colors, but only if you and other people are using Excel for ...
2
votes
1answer
14 views

Google Sheets date conditional formatting

I have dates in column D in Google Sheets. I want the cells to highlight red if 30 days have passed and there is not a comment date in column F. Example: Column D: Submittal Date 6/29/2019 ...

15 30 50 per page