Spreadsheet: 719054d1613488025-trying-to-get-a-text-cell-with-2-options-to-trigger-a-formula-in-another-cell-master-score-card-work-in-progress
Sheet: Master Report 2020

CLOSE | CLIENT NAME | CITY | SELLING | LIST OR | BUYERS | SRE | CLIENT | SOURCE | AGENT
DATE |  |  | PRICE | BUY | AGENT % | FEE | SAVINGS
2020-07-10 00:00:00 | [NAME] | St. Paul | 325500 | List | 0.024 | 5000 |  | Personal Ref. | [NAME]
2020-07-24 00:00:00 | [NAME] | [NAME] | 516000 | List | 0.024 | 5000 |  | Prospecting | Connor
2020-08-17 00:00:00 | Zach Eldridge-Brown | Hastings | 274900 | Buy | 0.027 |  |  | Prospecting | Connor
2020-08-19 00:00:00 | Lissa & Eruico | [NAME] | 328000 | List | 0.02 | 5000 |  | Radio | Connor
2020-08-19 00:00:00 | David & Stacy Southward | Cottage Grove | 312500 | List | 0.02 | 5000 |  | Radio | Connor
2020-08-21 00:00:00 | Scott & [NAME] | Shakopee | 375000 | List | 0.024 | 5000 |  | AD | [NAME]
2020-08-21 00:00:00 | [NAME] | Apple Valley | 280000 | List | 0.02 | 5000 |  | Company Lead | [NAME]
2020-08-27 00:00:00 | Cody Spahr | Rosemount | 340000 | Buy | 0.027 |  |  | Personal Sphere | [NAME]
2020-08-28 00:00:00 | [NAME] | [NAME] | 210000 | Buy | 0.027 |  |  | YLOPO | Scott
2020-08-31 00:00:00 | [NAME] | Little Canada | 445000 | List | 0.024 | 5000 |  | Company Lead | [NAME]
2020-08-31 00:00:00 | [NAME] | Inver Grove | 408000 | List | 0.022 | 5000 |  | Personal Sphere | [NAME]
2020-09-18 00:00:00 | [NAME] LLC | St. Paul | 130000 | Buy | 0 | 0 |  | Hoyt = Rehab | [NAME]
2020-09-22 00:00:00 | [NAME] | Hastings | 371000 | Buy | 0.027 |  |  | Radio | [NAME]
2020-09-22 00:00:00 | Kristine Kehn & Mark Dressen | Minneapolis | 451000 | List | 0.024 | 5000 |  | Company Lead | [NAME]
2020-09-24 00:00:00 | [NAME] | Minneapolis | 314700 | List | 0.024 | 5000 |  | Company Lead | Scott
2020-10-06 00:00:00 | [NAME] | Woodbury | 487000 | Buy | 0.03 |  |  | Prospecting | [NAME]
2020-10-15 00:00:00 | Kim & Chris Smith | Savage | 575000 | List | 0.02 | 5000 |  | Radio | Connor
2020-10-15 00:00:00 | [NAME] & [NAME] | St. Paul | 326000 | List | 0.02 | 5000 |  | Radio | Connor
2020-10-15 00:00:00 | Kim & Chris Smith | Plymouth | 365000 | Buy | 0.027 |  |  | Radio | Connor
2020-10-15 00:00:00 | [NAME] [NAME] | Scandia | 398000 | List | 0.02 | 5000 |  | AD | Scott
2020-10-23 00:00:00 | Trisha Schmidt & Scott Johnson | Otsego | 285000 | List | 0.024 | 5000 |  | Radio | Scott
2020-10-29 00:00:00 | Scott & Christine Heinl | Oakdale | 400000 | List | 0.024 | 5000 |  | Radio | Scott
2020-11-03 00:00:00 | [NAME] | Little Canada | 340000 | Buy | 0.027 |  |  | Radio | [NAME]
2020-11-05 00:00:00 | [NAME] | St. Michael | 227000 | List | 0.02 | 5000 |  | ? | [NAME]
2020-11-13 00:00:00 | [NAME] | Hastings | 235000 | List | 0.02 | 4500 |  | Past Client | Scott
2020-11-16 00:00:00 | Nick & Marianna Footh | St. Paul | 420000 | Buy | 0.027 |  |  | Personal | Connor
2020-11-16 00:00:00 | [NAME] | Cottage Grove | 295000 | List | 0.02 | 5000 |  | Radio | Connor
2020-11-16 00:00:00 | Nick & Marianna Footh | St. Paul | 330000 | List | 0.02 | 5000 |  | Personal | Connor
2020-11-16 00:00:00 | [NAME] | [NAME] | 138000 | Buy | 0.027 |  |  | Open House | [NAME]
2020-11-16 00:00:00 | [NAME] | Maplewood | 236000 | List | 0.02 | 4500 |  | KQRS Phone | Scott
2020-11-16 00:00:00 | Matthew Jacobson & Maureen Zook | [NAME] | 431000 | List | 0.022 | 5000 |  | KQRS Phone | Scott
2020-11-17 00:00:00 | [NAME] | Chanhassen | 280000 | List | 0.02 | 5000 |  | Radio | [NAME]
2020-11-20 00:00:00 | [NAME] | Minneapolis | 252000 | List | 0.022 | 4500 |  | KQRS Phone | Scott
2020-11-20 00:00:00 | [NAME] | St. Michael | 614595 | Buy | 0.027 | 500 |  | Database | Scott
2020-11-25 00:00:00 | [NAME] | Lakeville | 365000 | List | 0.024 | 5000 |  | KQRS Phone | Scott
2020-11-30 00:00:00 | Laura & [NAME] | Waterville | 347000 | List | 0.024 | 5000 |  | Radio | [NAME]
2020-11-30 00:00:00 | [NAME] | Andover | 290000 | List | 0.02 | 5000 |  | ? | [NAME]
2020-12-01 00:00:00 | Judy & James Grygar | Brooklyn Park/MPLS | 316000 | List | 0.02 | 5000 |  | ? | Connor
2020-12-03 00:00:00 | Gemechu Weyo | Farmington | 280000 | Buy | 0.027 | 500 |  | Personal Database | Scott
2020-12-10 00:00:00 | Dennis & [NAME] | Cottage Grove | 388500 | List | 0.02 | 5000 |  | Radio | Conor
2020-12-11 00:00:00 | [NAME] | Hastings | 292500 | Buy | 0.025 | 7313 |  | Personal | Connor
2020-12-11 00:00:00 | [NAME] | [NAME] | 352000 | List | 0.024 | 4500 |  | ORE FB | Scott
2020-12-15 00:00:00 | Rhonda Burling & [NAME] | Elk River | 377000 | List | 0.024 | 5000 |  | KQRS Phone | Scott
2020-12-18 00:00:00 | Gregg & Polly Hanson | Lakeville | 390000 | Buy | 0.027 | 500 |  | Radio | Connor
2020-12-18 00:00:00 | Gregg & Polly Hanson | Minneapolis | 382000 | List | 0.02 | 5000 |  | Radio | Connor
2020-12-23 00:00:00 | Alton & [NAME] | Minneapolis | 353000 | List | 0.024 | 5000 |  | Radio | [NAME]
2020-12-28 00:00:00 | Jenell & Jeremy Frailey | [NAME] | 330000 | List | 0.024 | 5000 |  | Radio | Scott
2020-12-28 00:00:00 | [NAME] ([NAME]) | [NAME] | 250000 | List | 0.02 | 5000 |  | REHAB HOUSE | [NAME]
2021-05-14 00:00:00 | Tyler & Jennifer Young | Rosemount | 476450 | Buy | 12864.15 |  |  | Sign | [NAME]
CLOSE | CLIENT NAME | CITY | SELLING | LIST OR | BUYERS | SRE | CLIENT | SOURCE | AGENT
DATE |  |  | PRICE | BUY | AGENT % | FEE | SAVINGS