Conditional/Pivot table LOOKUPS

Topic Labels: Formulas
1668 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I would like to be able to only pull up records in a LOOKUP field if they match specific criteria. For example, in one table I have a list of classes with a corresponding field telling me what “Zone” or location they are in. For example:

Class 1 Zone 2
Class 2 Zone 3
Class 3 Zone 4
Class 4 Zone 2

Then in another table I would like to be able to only LOOKUP all the classes that ,meet an existing criteria but only display classes that are also filtered by the Zone in that row. For example:

Mondays Class 1, Class 4 Zone 2
Tuesdays Class 2 Zone 3

I want the LOOKUP field in the first row to only pull up the classes in Zone 2. Where as the the second row would pull up classes that are in Zone 3.

Is this possible?

1 Reply 1

Most of what you want to achieve can probably be done by Grouping and Filtering. Group By Zone or Group By day of the week. Apply whatever filters you want and save as different Views.

You might also want to consider having a separate table for Zones and using Link To Record to connect classes to their zones.