U
U
Usmekhaiouschiysia2020-03-09 12:07:34
Google Sheets
Usmekhaiouschiysia, 2020-03-09 12:07:34

How to simply display cell comments from sheet to sheet in google sheets?

There is a plate with the hourly schedule of employees - each employee has a separate sheet to which he has access and which he can edit.

And since there are several dozen employees, there is also a collection sheet in which their schedules are collected, and on which you can see exactly how and at what hours they are loaded.
Through conditional formatting, you can see without much pain - yeah, this one has such and such free hours.

All this is convenient enough for a quick review, but here comes additional information. Certain hours for an employee can be occupied for a certain number. For example, from April, an employee will have free hours on Monday.

And employees begin to write this in the comments to the cells. For example, "from January, free hours", or vice versa, "from such and such a number are busy."

But if the actual contents of the cells are linked simply, through ='employee's full name'!C1 , then it's not clear how to extract a comment from the cell. Google Api seems to be able to pick up only notes, but even so it turns out that you need to write a rather complicated script for each employee separately. However, this can also be acceptable if there is no cleaner solution.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question