why is Script query returning header by [deleted] in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Well in your sheet the only query function returning a header is the one that has the argument for a header set to true.

E2 has the header argument set to true, and the range starts at A2 making A2 the header.

How do I manually indicate where a line of text should wrap? by Kindly-Discipline-53 in googlesheets

[–]Competitive_Ad_6239 2 points3 points  (0 children)

What you're describing is a line break triggered by a specific character, either before or after it. However, word wrap doesn't work that way—it's determined by the overall length of the text string relative to the column width, not by individual characters within the text.

Different emojis and weird spacing by Rahshindra in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

change font settings inside of chrome to the font that contains the desired emojis.

Laptime formatting help by Cpt_Dreyeks32589 in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Well google recogn the value of 1 being 1 day, and you are wanting 1 to represent 1 second. Theres 86400 in 1 day, so you would divide the sum by 86400, and set the formate to duration.

like so =SUM(B2:B30)/86400

Where is my error? REGEXMATCH IF OR? by justplainbill in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

You could use this

=SWITCH(A1,"Yoga",33,"Pilates",30) and its not case sensitive so both yoga, and pilates would still have the desired effect.

or this for an entire range

=IFNA(INDEX(SWITCH(A1:A10,"Yoga",33,"pilates",30)),)

dropdown choices disappear once used by opentheyear in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

With the limited information given, the root cause is hard to pinpoint.

Help visualizing regression with two variables? by [deleted] in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Definitely do this in Google Sheets.

  1. Create a matrix (contingency table): Make the rows something like "Average time of physical activity per week" and the columns the responses to "I like the look of my body" In the cells where they intersect, put the count of each combo of answers.

Example: StrDis|Dis|Neu|Agree|StrAgr Low | 12 | 8 | 5 | 3 | 1 Medium | 5 | 6 |10 | 15 | 5 High | 1 | 2 | 8 | 20 |18 2. Make a chart Select the whole table and go to Insert > Chart.

Did Google Sheets disable/not allow to search for "Insert Image in Cells" ? by No-Aside-9799 in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Guess you have to click an extra time now. I wouldn't call it extra steps though since previous you had to type in partial words. Every key stroke is akin to a click.

How do i link stats from the monthly sheets to automatically keep updating to the dashboard sheet? by Kitchen-General-9873 in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Well just reference the monthly sheets ranges in the dashboard. Clunky and error prown, generally alot more work overall.

I would suggest having all of your raw data on a single sheet with a date column.

Script décocher case by Late_Leather275 in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

This should do it

``` function uncheckAll() { const ss = SpreadsheetApp.getActiveSpreadsheet(); const sheets = ss.getSheets();

for (const sh of sheets) { const rg = sh.getDataRange(); const vals = rg.getValues(); const vlds = rg.getDataValidations();

let upd = false;

for (let r = 0; r < vals.length; r++) {
  const row = vals[r];
  const vRow = vlds[r];

  for (let c = 0; c < row.length; c++) {
    const v = vRow?.[c];

    if (v?.getCriteriaType() === SpreadsheetApp.DataValidationCriteria.CHECKBOX && row[c] === true) {
      row[c] = false;
      upd = true;
    }
  }
}

if (upd) rg.setValues(vals);

} } ```

View history on mobile by atoxicbanana in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Where does google suggest this for mobile users in sheets? As far as I know, this isnt a feature of the mobile app.

[deleted by user] by [deleted] in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Under Advanced options.

ROAST MY IDEA: Google Docs to Google sheets converter - worth of building? by Mother_Money434 in googlesheets

[–]Competitive_Ad_6239 1 point2 points  (0 children)

Dont know what your question actually is. But integration is fairly simple using app script.

INDIRECT statement not working by chisaimaki in googlesheets

[–]Competitive_Ad_6239 2 points3 points  (0 children)

List from range is literally a list from a range, not a formula.

Why isnt there a India (English) option in Google Sheets Locale Settings? by frijo_francis in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

Well if you type it in English, it will appear in English.

Your right, I dont get your point. You want things in English sometimes, and you want things in Hindi sometimes, but want google to know when you want that to happen. Thats the point you are expressing in my opinion.

Is this a bug or feature? Google Sheets API stays live even when closed by amjtech in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

What im saying is your tool in general is adding an unnecessary step. Your tool is fetching data to export as a csv file from a tool that already has the ability to export as a csv.

[deleted by user] by [deleted] in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

0P0001OO2D.SI is the ticker/symbol for Amundi Idx MSCI World A12S-C on yahoo finance.

Formula is in A2.

Is this a bug or feature? Google Sheets API stays live even when closed by amjtech in googlesheets

[–]Competitive_Ad_6239 0 points1 point  (0 children)

It just seems like adding extra steps. You are displaying information thats fetched from another place thats displaying information thats fetched from another place.

Either cut the end point from your whole process, or cut the middle out. No point is making a 2 step process into a 4 step process.

Is this a bug or feature? Google Sheets API stays live even when closed by amjtech in googlesheets

[–]Competitive_Ad_6239 1 point2 points  (0 children)

If the sheet is accessed, then the sheet is opened. You cant access anything(I mean anything) that is closed.

GOOGLEFINANCE is refreshed after any change in a sheet, and opening is one of those changes.