Help

Using Formulas with different worksheets

Topic Labels: Formulas
402 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Emmasu
4 - Data Explorer
4 - Data Explorer

Hi, sorry in advance if this question has already been answered.

I would like to compare two sets of date from different table, in the Table A I have a field with single select date that i want to compare with the Table B with multiple select, if in the Table B one of the data is the same I want to show the name of the person. 

If you need a context, I want to see the mentors that can help a student from a field that they choose, the mentors have given us many area of expertise and the student just one area of expertise, so from those two datas i want to do the matching and see the name of the mentors that can help this student.

Thanks in advance!

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @Emmasu ,

It is possible with automation.
Automation is triggered when a single select date is entered and updated in Table A (student list).
The mentor must be asked to enter the date in advance.

Automation:

  • When a record is updated
    Watch the date field of Table A
  • Find records
    Find multi-select dates in Table B that contain any of the dates in Table A
  • Update record
    Update list of mentor names in the Single line text field
    or update the list of record IDs in the Record Link field

How about this?

TheTimeSavingCo
18 - Pluto
18 - Pluto

You could also try creating a new table called "Expertise" and converting your select fields to linked fields to that table.  You can then just add a lookup field in Table A to pull over the Mentors that have that expertise set