Apr 19, 2016 07:37 PM
Hey all,
I stumbled upon Airtable and love the look of the site. However, I have no idea if the software is advanced enough to handle what I use Google Sheets for. Hopefully someone here that’s more familiar with the functions of Airtable can let me know!
Right now, I use Sheets to dump data I scraped from Indeed.com, de-dupe it, and keep status records of what I’ve done with each record. My workflow is this:
I would think the Unique function is relatively easy to implement as well. What I’m not sure of is the last part of my sheet.
I have a “Master Key” sheet where I put a company that I know will be listed multiple times, but will all have the same status. For example, there are a lot of job ostings from Amazon LLC, which is too big for me. So I put it in the “Master Key” and write “Too Big” next to it. Then in an Auto Status column in my “Unique” page I write this formula - =IF(B2="","",INDEX(‘Master Key’!$B:$B,MATCH(B2,‘Master Key’!$A:$A,0)))
This auto checks and marks all instances of Amazon LLC as “Too Big” and then the conditional formatting crosses it off.
Does this sound like something that can be done with Airtable? I can clean up a copy of a sheet of mine to share with you just to give you the idea, let me know if someone would like me to!
Best,
Scott
Apr 19, 2016 09:33 PM
A few people want the same thing as you