I’m trying to make an exhaustive list for a daily inventory that my workers need to do. I already solved the no duplicates by selecting [Date] and [Moment] (this has an app formula that tells weather is in the morning or in the evening) and the [Product] as a CONCATENATED KEY. I would like that once there is a product that fills all of the above it would appear with a strikethrough so that my workers know they already selected that one. Finally, it’s a dropdown list, so the data ir located in another sheet.
Another way I tried was with the Distinct value dropdown app example but it keeps appearing a warning symbol next to the dropdown values. What am I missing?
Thanks for your help!