Skip to main content

Using Formulas with different worksheets

  • July 21, 2023
  • 2 replies
  • 14 views
E
Forum|alt.badge.img

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

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • 560 replies
  • July 21, 2023

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
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement