I'm a teacher and I'm trying to set up a spreadsheet with students' grades that will link to an individual spreadsheet with the header from spreadsheet#1 plus the row that has an individual's grades. I want the formatting to copy over as well. I see how I can do that with the importrange() function and copy the formatting with a script, but I want the "comments" to transfer over as well. Is this possible? Is it possible to transfer merged cells? Does anyone have a more simple idea for copying formatting than what was discussed here: Cell reference with colour formatting ?
Google-sheets – How to link cells from one sheet to another sheet and keep formatting and comments
google sheets
Related Topic
- Google-sheets – Can you restrict Google Sheet to editing just text with restrictions on formatting
- Google-sheets – Inserting text from a cell into an IMPORTRANGE formula
- Google-sheets – How to search for a value in another sheet (same document) and return value
- Google-sheets – Conditional Formatting based on another sheet, tying a value to a colour, Google Sheets
- Google-sheets – How to Copy Cell Value and Format From One Tab to Another Using a Formula
Best Answer
Comments
Comments cannot be copied. They are not considered part of the contents of a spreadsheet, they are more like chat messages, the record of a conversation that took place about that spreadsheet. If there was no such conversation about a copy of that spreadsheet, comments won't be there.
Alternative: use notes instead of comments. They get copied same way as cell contents.
Formatting
In the situation you have, it'd be better to create a blank template of grade report, with all the formatting, and then copy that to individual students.
importrange
is meant for importing data, not formatting. (Also, it does not import notes or comments.)