Strikethrough a Dropdown List

Hi guys,

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!

@AlejandroCamacho - is there a reason you want the dropdownlist item to be “strike through” rather than not having completed items appear in the list at all? If the latter, Dependent Dropdowns” should work:

I have not tried to create strikethroughs in drop downs. I don’t think the format rules will show in the drop down…

Hi Mike, thanks for your reply.

Because I chose to use the Concatenated Key as my solution to avoid users from submitting duplicates, if the user selects an item from the list it will say that it is not available. They have to inventory around 50 items so I dont want them to waste any time by figuring out which item is missing to submit. That’s why I though of a strikethrough…

I also tried to reference them, though the problem is that I need the key values to reset every day so that the users can select again the same values and do the inventory once again.

I was also trying to figure out how to do a multiple dropdown as show below:

I want to show the values of [Descripción] that fulfill the conditions of the two previous columns. Tried with SELECT(GLOSARIO INVENTARIO[DESCRIPCIÓN], AND([FRECUENCIA] = [_THISROW].[FRECUENCIA], [HABILITADO] = TRUE)) but it does not recognize changes in the table, so it’s not dynamic.

Thanks again for your help!

There is no way to strike-through a drop-down menu item that I’m aware of. From a usability perspective, such list entries would clutter the list and make finding available items more difficult. There would also be no way to prevent a user from (accidentally) selecting the stricken options. Better to remove the unavailable options from the drop-down entirely.

Thanks Steve, I’ve tried to remove the unavailable options from the dropdown but it is a dependent dropdown and some warning symbols appear next to the list of values:


Can’t tell why the entry is invalid…

In my experience, the yellow triangle means the value is an invalid reference: the value is expected to be a key column value in a referenced table, but the value does not match an existing key column value in that table.

Hi again Steve!

So I changed the key value of my information table to match the target column and it worked!

Now the thing is that I am missing the dependent dropdown, any ideas? Thank you so much!

1 Like

Worry not, I already figure it out by using a Select(). Thanks again!

1 Like