Sorry, I'm not using excel, I'm using airtable. am I missing something?
Hmm, could you provide some screenshots of Table A and Table B with the relevant fields, with some example data and example output? Would love to help but don't have enough information!
TheTimeSavingCo wrote:
Hmm, could you provide some screenshots of Table A and Table B with the relevant fields, with some example data and example output? Would love to help but don't have enough information!
here you go!
https://www.loom.com/share/c45438baef264aee9bc408fef0df70c6?sid=cdb48c1b-f513-41c1-96e2-7959d9f8fb86
Courtenay_Ricke wrote:
Thanks! Yeah we can do this with an automation without any scripting. Try setting it up like this:

And you can view the actual setup via the link below:
Link to base
