Now all we need to do is pass that back to Google Sheets in an Update Row action. If we were to run that exact formula, we would get a result of “1”. At the end of the day, we get something like this: This is easy enough - just put a “+” between each IF formula. The last thing to do is to add them all up. Notice the quotes around these fields - any time we’re using text, we have to make sure to use quotes, or the formatter will get confused. The first IF formula would look something like this: IF("="Manufacturing",1,0) We’ll use an IF statement to generate either a 1 or a 0 for each of those, then add them all up. Now we know what we’re working with, so it’s time to build a formula. They’ll get 1 point if they’ve viewed our page >20 times, 1 if their industry is Manufacturing, and 1 if they have an immediate need, for up to 3 possible points. The three highlighted columns will be used to score the lead.
Let’s look at the leads first so we can get an idea of what kind of data we have to work with: Instead, I finally realized I could use my favorite formatter, the Spreadsheet-Style Formula, and a few IFs added together. Initially, we were working on using a series of Paths and math formulas, but that wasn’t working very well. In this way, you could tally a final score for that Lead.
If they were also in the Manufacturing industry, they would get an additional point. For example, if a customer said they had an immediate need, they would get 1 point. I had a customer recently whose goal was to score leads based on special criteria they had determined to be important. This Wednesday, I’d like to discuss using multiple IF statements to score a lead based on specific criteria. Hi, I’m Clint, a Customer Champion at Zapier! I’m obsessed with Google Sheets, Zap loops, and edge cases.