Working on a check in app for our activations. Have 3 smartsheets:
- Personnel roster
- Locker number list
- Bunk number list
For the bunk number list we want to only show bunks based on power need, and preference of top/bottom bunk.
Is there a way to set this up so that the list of bunks filters first for power (y/n), then top/bottom (y/n), while at the same time only showing bunks not already assigned?
I’ve been able to use the data validity successfully for assigned/not assigned - but not three items like this. Any suggestions would be greatly appreciated. They’ve given me until Wednesday to come up with version1 , yay?!