Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Filter by column

Topic Labels: Formulas
1249 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ondratyle
4 - Data Explorer
4 - Data Explorer

Hello,

I have Table of people and for eveybody I have registration month by number. 

It looks like that: Name:Adam, Registered:9

Than I have second table with courses. For each course I have assigned that people. The cource has its own month.

For example: Yoga:Adam,Robert, Month:9

I would like to have new column, that will include only the people that was registered in the same month as the course.

The month is different for each course so I cannot use the filter function in rollup. Please help.

3 Replies 3
AmandaWhiting
4 - Data Explorer
4 - Data Explorer

Hello,

Are the people you have assigned in Table 2 records linked or just names? 

ondratyle
4 - Data Explorer
4 - Data Explorer

Yes, they are linked.

Screen Shot 2023-09-15 at 9.15.29 PM.png

Screen Shot 2023-09-15 at 9.15.41 PM.png

I've had this same issue in the past so I made a mock table. Is this what you would want your 2 tables to look like?