Answer

Welcome to the nostalgia-filled piefed instance of yesteryear.

Open Registration with Application questionnaire.

If you have a question or comment you can post in !meta@retrofed.com or message @DosDude@retrofed.com or @Die4Ever@retrofed.com

In case of downtime and/or emergency, we will post updates on @DosDude@mastodon.social

Some rules we try to uphold:

Be civil. Bigotry is not welcome. This includes (but is not limited to): transphobia, queerphobia, racism, ageism and ableism. We do not promote hate.
Communities need to be Retro or Retro-adjacent.
Please don't upload pornographic content. (use an external image host for that)

boredsquirrel@slrpnk.net Joined: 2024-04-11

There are many cases when people might want to have a dropdown list of the other entered values in a column.

And the ability to prohibit entering others.

Classic one: entering yes, no, maybe.

These are not boolean, but discrete, and others should not be allowed.

Do you know how to do that?

Answer

source

select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK

Here is an example.

Thanks @Aufgehtsabgehts@feddit.org

Ende Gelände!

Welcome to the nostalgia-filled piefed instance of yesteryear.

Open Registration with Application questionnaire.

If you have a question or comment you can post in !meta@retrofed.com or message @DosDude@retrofed.com or @Die4Ever@retrofed.com

In case of downtime and/or emergency, we will post updates on @DosDude@mastodon.social

Some rules we try to uphold:

Be civil. Bigotry is not welcome. This includes (but is not limited to): transphobia, queerphobia, racism, ageism and ableism. We do not promote hate.
Communities need to be Retro or Retro-adjacent.
Please don't upload pornographic content. (use an external image host for that)