求助：将Google Sheet数据库表最后一行数据复制到检查表

Hey there! Since you're new to working with Google Sheets formulas, let's walk through exactly how to get this set up. You already have a great starting point with that FILTER formula—we just need to tweak it to work across your two sheets.

Here's what you need to do: #

1. Open your Checklist spreadsheet and navigate to Sheet1.
2. Pick the cell where you want the first value of the last row from Database to appear (most likely cell A1).
3. Paste this adjusted formula:

   =FILTER('Database'!Sheet1:A:Z, ROW('Database'!Sheet1:A:A) = MAX(FILTER(ROW('Database'!Sheet1:A:A), NOT(ISBLANK('Database'!Sheet1:A:A)))))
   

   Let me break this down a bit:
   • 'Database'!Sheet1:A:Z refers to all columns from A to Z in Database's Sheet1 (adjust the Z to whatever your last column is if needed).
   • The inner FILTER finds all row numbers in Database where column A isn't blank, then MAX grabs the highest row number (that's your last filled row).
   • The outer FILTER then pulls all the data from that specific row across your columns.

If you only need specific columns instead of the whole row: #

Say you just need columns A, C, and E—modify the formula to target those columns directly:

=FILTER({'Database'!Sheet1:A:A, 'Database'!Sheet1:C:C, 'Database'!Sheet1:E:E}, ROW('Database'!Sheet1:A:A) = MAX(FILTER(ROW('Database'!Sheet1:A:A), NOT(ISBLANK('Database'!Sheet1:A:A)))))

Quick notes to keep in mind: #

• Make sure your Database spreadsheet is shared with the same account you're using for Checklist (or set to "Anyone with link can view" if it's public) so the formula can pull the data.
• If your last filled row might have blank cells in column A but data in other columns, adjust the NOT(ISBLANK('Database'!Sheet1:A:A)) part to reference a column that will always have data in every filled row (like an ID column, if you have one).

内容的提问来源于stack exchange，提问作者L. Gold