Make a list in a slice get smaller as you complete items

I have an app where a worker must check the same machines daily. In the first version, I compiled a list at the end of the day. A worker could look back and see what they DID. But, with over 100 machines to look over, all the numbers tend to blend. So, I am thinking that I would rather have a daily list slice start with the 100 machines. When you complete a machine, it drops from the list. So a โ€œWork Left To Doโ€ list.

I have my master data table. I have it ref a different table with all of the machine numbers.
The master data table uses [timestamp] as a key. There is no timestamp on the 2nd worksheet.

On the Data/Slices settings, the Source Table allows me to reference one table or the other, not both. But the idea I am thinking is [Machine] AND [Timestamp]>Today.

Any suggestions on how to solve 2 problems (maybe more, if the need arises)?
1: List that gets smaller as you do it.
2. Resets daily.

0 2 333
2 REPLIES 2
Top Labels in this Space