3
[Question] [Google Sheets] Is there a way to automate matching form entries using criteria? (lemmy.world)
submitted 11 months ago by 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
[–] [S] 1 point 11 months ago (2 children)

A little more complex.

So say I have John, Jane, Max, and Susan. John has $25 and lives in Seattle. Jane needs $50 and lives in New York City. Max has $100 and lives in New York City. Susan needs $25 and lives in Seattle.

I would match John with Susan and Jane with Max, right?

Is there a way to get the spreadsheet to tell me that?

And then if I were to add Jim who has $30 and lives in Seattle, can I get the spreadsheet to match both Jim and John to Susan?

Conditional formatting might work at this scale, but what if I had 50 people and also added additional criteria? So instead of just budget and city, maybe there's a store name. Maybe they only match 2/3 of the criteria.

What would I do?

🤔🤔

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 2 points 11 months ago (1 child)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •