About sheet coordination in spreadsheets

Asked 2 years ago, Updated 2 years ago, 141 views

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

2022-09-29 21:32

1 Answers

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?


2022-09-29 21:32

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.