Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question