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!