[Question] [Google Sheets] Is there a way to automate matching form entries using criteria? (lemmy.world)

submitted 3 months ago by acetanilide@lemmy.world to c/spreadsheets@lemmy.ml

4 comments fedilink hide all child comments

Hello!

I am using a Google form to connect people who have stuff with people who need stuff.

The form gets name, contact info, location, and other details from both types of people.

How can I automate matching both types of people together using the details I receive?

Please don't say AI, as there is contact info I can't put in a bot.

Thanks!!

you are viewing a single comment's thread
view the rest of the comments

[-] Flagstaff@programming.dev 2 points 3 months ago

Wow. Thanks for the example. That's kinda crazy and asking way beyond what a spreadsheet's formulas could typically do. You're basically asking to write an algorithm. I don't know if I'd even have the expertise to write an optimal script in !ahk@programming.dev, but I could try. But I do believe that you're posting this question in the wrong community.

[-] acetanilide@lemmy.world 1 points 3 months ago

Thanks! You're right aha. Appreciate it

this post was submitted on 30 Oct 2025

2 points (100.0% liked)

Spreadsheets

54 readers

1 users here now

founded 2 years ago

MODERATORS

maxprime@lemmy.ml