Help on Index(collect) to drag the values down
I have a source sheet which receives value from a DB and this sheet keeps updating on daily basis. I have added 2 new columns in the source sheet as "CreatedDate" and "Status". The "Status" value had a formula o update the value as 1 if the record is latest and 0 if the record is old. So whenever there new data is added to the source sheet , the value in "Status" column is updated to 0 or 1 accordingly.
Now I have to create a lookup in another sheet(finalsheet) to just display the records with value as 1 and this should always give real-time value.
Note: I tried copy workflow with condition, but then the finalsheet is having duplicate records because a record when has the value as 1 is updated in finalsheet. But when there is an update in the source sheet, and this record has value has 0, its not updated in the final sheet.