Here’s the scenario: Every year my friends and I go on a trip to Comic Con, and we split hotel rooms. I’m putting together an expense tracker to keep up with this. We sometimes have more than one hotel room, so I want to assign people in the list to a room, which is a row in the “rooms” table To a…

Here ya go. I actually figured out how to use references, so I’m a step closer. I can get the linked reference of the list of nights in the other table. But now, in the attendees table, I want “hotel nights” to be a drop down that I can select different nights. So, for example, Joe may stay every n…

If you remove the column formula on Hotel Nights then that is a dropdown you can select from.

How to change a dropdown column based on a previous column

mallika March 14, 2019, 8:25pm 2

Hi @Joseph_Blake - if the data is not private or if you can create a sample doc with the two tables would you mind sharing it here. That will help us see the setup and column formats and help faster.

Topic		Replies	Views
Dropdown Menu Dependancies?	37	8646	April 4, 2025
Dynamic select list items based on a lookup column	4	4165	January 17, 2020
Change referenced table through select list	5	799	May 23, 2019
Retrieve all selectable items from a list column	3	1576	December 29, 2018
Dropdown dependency selection	4	806	November 26, 2020

How to change a dropdown column based on a previous column

Related topics