How do I get responses in Google Forms to automatically be updated when updating the spreadsheet?

I’m in a situation, where I have been given a source of information, with all sorts of people. And with that, I wish to insert all this inside of Google Forms, in the response section. And so I was wondering, if I could simply insert all this inside of the spreadsheet, for the response destination. Is this possible, and how could I do it?

Copy Sheet To New Spreadsheet

I want to copy one sheet in the Spreadsheet file into a new Spreadsheet file. The sheet that I want to copy contains formulas, I want to just copy the value to a new Spreadsheet file.

enter image description here I have made the script like this:

function makecopyto() {   const folderId = '1Y7RmeF9sluTndSUr2KQT8wlOL9oUkLVU';   const ss = SpreadsheetApp.getActiveSpreadsheet();   const sheet = ss.getSheetByName('Sheet1');   const newSsName = sheet.getRange('Sheet2!F1').getValue().toString();   const resource = {     title: newSsName,     mimeType: MimeType.GOOGLE_SHEETS,     parents: [{ id: folderId }]   };   const fileJson = Drive.Files.insert(resource);   const targetSs = SpreadsheetApp.openById(fileJson.id);   const targetSheet = sheet.copyTo(targetSs); } 

But the results are not appropriate.

enter image description here

The results I want should be like this: enter image description here

Funny alignment in google spreadsheet

This is driving me crazy. I have searched the web for an answer, without success. All results are simple pointers to how to use the formatting on the sheets. This mis-alignment seems to be something Google sheets just decided to do on its own.

I have a spreadsheet with some numerical data, and some cells with values which are functions of other cells.

The inputs are horizontally centered, and the outputs are right-justified.
But some of these output cells have a small right margin, and I cannot make it go away or figure out what causes it.

If I specify right-justified, they shift a little to the left (red cells)
If I specify centered, they misalign, but by less. (green cells)
If I specify left-justified, they line up. (blue cells)

DETAILS FOLLOW:

Description of cells:
C10 through I29 are the inputs (not all are filled in).

(Red) B32 =sum(C10:I10,C21:I21,C29) –> Has margin
(Red) D32 =AVERAGE(C10:I10,C21:I21,C29:D29) –> Has margin
(Blk) D34 =average(C21:I21) –> Has no margin
(Blk) other nearby cells also –> no margins

Interesting fact: if I click cell D32 (has margin), and then the PaintBrush (to copy the format) and apply it to D34, D34 gets that margin, too! But without doing that, D34 has no margin.

Here is a link to the example sheet:
https://docs.google.com/spreadsheets/d/18lNIA3wBX5EOfvOD2EL5QmLxvKSDslqIfLsFFBWz7rE/edit#gid=0

Is it possible to export a simple .Numbers spreadsheet while being dynamic?

I am fairly new to all this, so Please for give me if this seems like a stupid question.

I have a few .Numbers Spreadsheet that I use to keep track of my budget over the weeks/months but its only accessible in Numbers, which is fine Until I am at work where we use windows and My iPhone is quite old so its Numbers is very slow on it. where as PDF reader are not.

Is it possible to export spreadsheet as a PDF document and still retain the automatic calculations of the spreadsheet and not just be a standard table?

Thank you.

How to add multiple digital signatures to an Excel spreadsheet?

I have an Excel spreadsheet that lives on a shared folder, that everybody can access. On that spreadsheet, I have a worksheet with a list of tasks that have to be completed, but not necessarily by the same person and certainly not at the same time (it takes about 2 weeks to complete all the tasks on that list).

I would like each person to sign off each task on the spreadsheet after it’s done so that we have a record of who did what and when. I have tried using the digital signature feature provided by Microsoft as detailed in https://support.office.com/en-us/article/add-or-remove-a-digital-signature-in-office-files-70d26dc9-be10-46f1-8efa-719c8b3f1a2d, the only problem is that it appears to be designed to be used only once per document.

Even though I am able to add multiple signature lines to the same spreadsheet, once one is signed, I get the following message:

enter image description here

If I choose “Edit Anyway”, the first signature disappears, even if I choose the level of commitment to “none”, which kind of defeats the purpose of having multiple signatures. The whole point is that the spreadsheet keeps being edited with more and more data added as the tasks are being completed and I just need a form of signature of who completed which task when, while being able to keep editing the spreadsheet in the meantime.

Can anybody recommend an alternative solution of a way to make the Microsoft digital signatures work for that use case? I have done quite a bit of searching and it looks like even though many people have reported the same issue, there is no solution offered.

How to import/merge data from from 2 separate sheets from another spreadsheet

I need to import data from “Spreadsheet A” to “Spreadsheet B” but all the data is in two separate sheets in “Spreadsheet A”

I basically need exactly this but with a function to import from another spreadsheet, not only within the same one

=QUERY({{ARRAYFORMULA(ROW(INDIRECT("A1:A"&COUNTA(QUERY(MY!A2:A; "select A where A is not null")))))\QUERY(MY!A2:A; "select A where A is not null")};  {ARRAYFORMULA(ROW(INDIRECT("A1:A"&COUNTA(QUERY(NY!A2:A; "select A where A is not null")))))\QUERY(NY!A2:A; "select A where A is not null")}}; "select Col2 order by Col1") 

Sort Google Spreadsheet by ‘alternating’ values in multiple columns

How can I sort a random list in Google Sheets so it returns alternating values? Is it possible to do it with multiple columns?

For example, can I alternate so each Room starting with the lowest has one Female and one Male but that alternates Category (4 total categories A,B,C,D) and it starts over after cycling through the set?

The current random list looks like this:

fName   lName   G   Cat Room ID ----------------------------------- Sara    Don     F   A   104  524134 Mark    Don     M   C   104  323124 Rose    Jones   F   D   101  145456 Mike    Jones   M   B   101  123456 Jane    Smith   F   B   103  321313 Kim     Holly   F   A   102  753951 Paul    Holly   M   C   102  745951 Dave    Smith   M   D   103  355353 Deb     Moore   F   D   105  574622 Al      Smith   M   B   105  355353 Rick    Smith   M   C   106  355353 Sara    Smith   F   A   106  355353 ... 

The desired list would look like this:

fName   lName   G   Cat Room ID ----------------------------------- Rose    Jones   F   D   101 145456 Mike    Jones   M   B   101 123456 Kim     Holly   F   A   102 753951 Paul    Holly   M   C   102 745951 Jane    Smith   F   B   103 321313 Dave    Smith   M   D   103 355353 Sara    Don     F   A   104 524134 Mark    Don     M   C   104 323124 Deb     Moore   F   D   105 574622 Al      Smith   M   B   105 355353 Sara    Smith   F   A   106 355353 Rick    Smith   M   C   106 355353 ...at the end of last Room start over with lowest room until the end of the list (the list below is just to show desired outcome the real list has different entires) Rose    Jones   F   D   101 145456 Mike    Jones   M   B   101 123456 Kim     Holly   F   A   102 753951 Paul    Holly   M   C   102 745951 Jane    Smith   F   B   103 321313 Dave    Smith   M   D   103 355353 Sara    Don     F   A   104 524134 Mark    Don     M   C   104 323124 Deb     Moore   F   D   105 574622 Al      Smith   M   B   105 355353 Sara    Smith   F   A   106 355353 Rick    Smith   M   C   106 355353 ... 

Google sheets, Using a checkbox to auto populate a Row on another spreadsheet

(see attached image)enter image description here

I have this spreadsheet which is used for receiving and recording work. SST responses is where people submit requests, Workload is where we record all work.

I’m wanting it so that when someone clicks the checkbox as completed it then populates a line in ‘Workload’ on the next available blank line with the information.

Cheers