About managing spreadsheets
There is sheet 1 of the basic product management calendar.
Release date (column A), product name (column B), and basic information (column C-G)
I would like to create and manage a check sheet for each task for the product.
The sheet per task (sheet 2) is
From sheet 1 (basic information),
I would like to link only the release date (column A) and product name (column B). Currently, only columns A and B are displayed as query functions, and check and note are listed after column C. There is a problem here.
Then, I think it would be better to add more rows to the basic sheet.
It seems inconvenient because there are so many tasks (there is a possibility that I will check the wrong line)
I would appreciate it if you could let me know.
Thank you for your cooperation.
google-apps-script google-spreadsheet
Do you mean that you are making hand-made sheets after row C?
Depending on what the task depends on, you can also place a key and task correspondence table on sheet 3 and
How about referring to sheet 3 in column C of sheet 2 or later in vlookup?
© 2024 OneMinuteCode. All rights reserved.