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.