Share
Report
108Gooooood afternoon!
Trying to develop a formula/lookup and I cannot get it to work.
I have table A (Recruitment) and table B (Appointment Form).
Table A records the new employee's name and email then a bunch of lookup columns to other tables for things like their project area.
Table B records additional data and must be completed for each employee in table A. There can be multiple records in this table so there is a ONE to ONE relationship from Table A to B.
I want to have a column in Table A that checks if an corresponding record (using email as the key) has been created in Table B. Sounds like a simple forumlaic IF(TABLE A EMAIL STRING in TABLE B EMAIL STRING , "YES" , "NO")
Simple in theory, but I cannot get it to work.
Advice would be appreciated!
All responses (
Answers (
