Filter Column not get updated

[davidhuang]

Column POPS is a list with filter on SpreadSheet A, I can add many records, save them to SpreadSheet B.

Column COST is a list with filter on SpreadSheet B.

The problem is, when I add a record to POPS and save data to SpreadSheet B, I expect the data of COST to be automatically updated, but it doesn’t. Any solutions? Thanks!