{"id":4355,"date":"2023-05-15T00:00:00","date_gmt":"2023-05-15T00:00:00","guid":{"rendered":"https:\/\/phantombuster.com\/blog\/google-sheets-formulas-cheat-sheet\/"},"modified":"2025-11-11T12:43:27","modified_gmt":"2025-11-11T12:43:27","slug":"google-sheets-formulas-cheat-sheet","status":"publish","type":"post","link":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/","title":{"rendered":"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &#038; Enrich Your Pipeline"},"content":{"rendered":"<p>Looking for the ultimate Google Sheets reference guide specifically designed for sales professionals? This Google Sheets cheat sheet covers all the essential formulas and features you need to manage prospects, track your pipeline, and analyze sales performance\u2014all tailored to real-world sales scenarios.<\/p>\n<p>For a complete reference of all Google Sheets functions, you can also check the <a class=\"underline\" href=\"https:\/\/support.google.com\/docs\/table\/25273?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\"><u>official Google documentation<\/u><\/a>.<\/p>\n<h2>AVERAGE, AVERAGEIF &amp; AVERAGEIFS: Calculate key sales metrics and performance indicators<\/h2>\n<p>These functions help you understand typical values in your sales data, from deal sizes to conversion rates, and return the numerical average value rounded to the nearest integer when needed.<\/p>\n<h3>AVERAGE syntax<\/h3>\n<p>Start each formula with an <strong>equal sign<\/strong> (=), followed by the function name:<\/p>\n<ul>\n<li>=AVERAGE(range) &#8211; average of all values<\/li>\n<li>=AVERAGEIF(range, criteria, [average_range]) &#8211; average if one condition is met<\/li>\n<li>=AVERAGEIFS(average_range, criteria_range1, criteria1, \u2026) &#8211; average with multiple conditions<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Get the average deal size for the &#8220;North&#8221; territory:<\/p>\n<pre class=\"codeblock\"><code>=AVERAGEIF(E2:E9, \"North\", H2:H9)<\/code><\/pre>\n<p><em>This returns the numerical average value in column H (deal amounts), but only for rows where column E (Territory) contains &#8220;North&#8221;.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/eb57c9df-71b8-4b31-8d22-5fcfa0d3cc0b.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Track average response time by lead source<\/li>\n<li>Measure average days to close by deal type<\/li>\n<li>Calculate average conversion rates by campaign<\/li>\n<\/ul>\n<h2>ARRAYFORMULA syntax<\/h2>\n<p>ARRAYFORMULA lets you perform calculations across entire ranges at once, eliminating the need to copy formulas down columns.<\/p>\n<h3>ARRAYFORMULA<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=ARRAYFORMULA(array_formula)<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Create standardized email addresses for all prospects in one formula:<\/p>\n<pre class=\"codeblock\"><code>=ARRAYFORMULA(LOWER(A2:A100)&amp;\".\"&amp;LOWER(B2:B100)&amp;\"@\"&amp;LOWER(C2:C100)&amp;\".com\")<\/code><\/pre>\n<p><em>This takes first names (A2:A100), last names (B2:B100), and company names (C2:C100) to generate email addresses in format <\/em><a href=\"mailto:firstname.lastname@company.com\" target=\"_blank\" rel=\"noopener noreferrer\"><em><u>firstname.lastname@company.com<\/u><\/em><\/a><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/a64e344f-9e04-4893-b378-63ca59fee779.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Calculate commission on every deal in your sales pipeline<\/li>\n<li>Create standardized tracking IDs for all prospects<\/li>\n<li>Apply lead scoring formulas to your entire database at once<\/li>\n<\/ul>\n<h2>CONCATENATE &amp; CONCAT: Combine fields for cleaner prospect tracking<\/h2>\n<p>Whether you&#8217;re prepping a contact list or syncing to your CRM, these formulas help you combine data fields from multiple cells like names, company, or job title into one clean string.<\/p>\n<h3>CONCATENATE &amp; CONCAT<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=CONCATENATE(text1, [text2], &#8230;) &#8211; Joins multiple text strings<\/li>\n<li>=CONCAT(text1, [text2], &#8230;) &#8211; Newer version with same functionality<\/li>\n<li>=text1&amp;text2&amp;text3 &#8211; Alternative using the ampersand operator<\/li>\n<\/ul>\n<blockquote><p>Tip: You can also use TEXTJOIN for more complex cases with delimiters.<\/p><\/blockquote>\n<p><strong>Sales example:<\/strong> Create a full name field for export<\/p>\n<p>Let\u2019s say your columns are:<\/p>\n<ul>\n<li>A = First name<\/li>\n<li>B = Last name<\/li>\n<li>C = Company<\/li>\n<\/ul>\n<h4><strong>Option 1: Combine manually (one row at a time)<\/strong><\/h4>\n<p>Use this if you\u2019re working with a short list.<\/p>\n<pre class=\"codeblock\"><code>=CONCATENATE(A2, \" \", B2, \" (\", C2, \")\")<\/code><\/pre>\n<p><em>This formula takes first name (A2), last name (B2), and company (C2) to generate something like: Alice Smith (TechCorp)<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/eb54dbad-2e00-4aad-b9c5-b0b9b18ff74c.png\" \/><\/p>\n<h4><strong>Option 2: Combine automatically with ARRAYFORMULA<\/strong><\/h4>\n<p>Use this when working with longer lists or dynamic data.<\/p>\n<pre class=\"codeblock\"><code>=ARRAYFORMULA(A2:A &amp; \" \" &amp; B2:B &amp; \" (\" &amp; C2:C &amp; \")\")<\/code><\/pre>\n<p>Same output, but for every row at once.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/650209bc-8551-4e33-9394-89e4c8777c89.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Standardize contact names before syncing with a <strong>CRM integration<\/strong><\/li>\n<li>Create dynamic tags for segmentation in your <strong>prospect<\/strong><strong> data management<\/strong> workflows<\/li>\n<li>Make your <strong>sales spreadsheet<\/strong> easier to scan, filter, or export<\/li>\n<\/ul>\n<h2>COUNT, COUNTA, COUNTIF &amp; COUNTIFS: Track your leads and activities by category<\/h2>\n<p>These formulas help you count deals, contacts, or actions based on custom criteria, such as deal status, lead source, or a specified value. It&#8217;s perfect for understanding pipeline health, campaign results, or rep activity.<\/p>\n<h3>COUNT, COUNTA, COUNTIF &amp; COUNTIFS<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=COUNT(range) \u2014 Counts numeric values in cells<\/li>\n<li>=COUNTA(range) \u2014 Counts non-empty cells<\/li>\n<li>=COUNTIF(range, criteria) \u2014 Counts cells in a specified range that match a given value<\/li>\n<li>=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]\u2026) \u2014 Counts based on multiple conditions<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Count qualified LinkedIn leads:<\/p>\n<pre class=\"codeblock\"><code>=COUNTIFS(G2:G9, \"Qualified\", F2:F9, \"LinkedIn\")<\/code><\/pre>\n<p><em>This counts all rows where column G = &#8220;Qualified&#8221; and column F = &#8220;LinkedIn&#8221;, ideal for tracking lead source performance.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/3f1e5739-d942-47d3-bae9-89f4126d0ee6.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Track outreach attempts by sales rep<\/li>\n<li>Measure follow-up completion rates<\/li>\n<li>Count leads by source or industry<\/li>\n<li>Calculate conversion rate between pipeline stages<\/li>\n<\/ul>\n<h2>DATE, TODAY &amp; NOW: Manage timelines and sales cycle duration<\/h2>\n<p>These functions help you calculate how long deals have been open based on the date value in each row.<\/p>\n<h3>DATE, TODAY &amp; NOW<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=TODAY() &#8211; Returns the current date<\/li>\n<li>=NOW() &#8211; Returns the current date and time<\/li>\n<li>=DATE(year, month, day) &#8211; Creates a date from individual components<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Calculate days since last contact with prospects:<\/p>\n<pre class=\"codeblock\"><code>=TODAY()-F5<\/code><\/pre>\n<p><em>Subtracts the date in cells from column F (last contact) from today&#8217;s date to get days elapsed<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/8f6a8c8f-98d7-4a9f-b741-c13ed223d756.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Prioritize outreach based on <strong>last touch<\/strong> or <strong>last meeting<\/strong><\/li>\n<li>Combine with IF to tag leads as \u201ccold\u201d after X days<\/li>\n<li>Filter your <strong>sales pipeline<\/strong> by stage age or response delays<\/li>\n<\/ul>\n<h2>FILTER: Extract high-value prospects based on multiple criteria<\/h2>\n<p>FILTER helps you create dynamic lists of prospects that meet specific criteria, perfect for targeted outreach campaigns.<\/p>\n<h3>FILTER<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=FILTER(range, condition1, [condition2, ...])<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Extract high-value leads with recent engagement:<\/p>\n<pre class=\"codeblock\"><code>=FILTER(A2:I59, E2:E50 = \"West\", I2:I50 &gt;= TODAY() - 30)\r\n<\/code><\/pre>\n<p>This returns all rows where Territory = &#8220;West&#8221; and Last Contact Date is within the past 30 days\u2014ideal for follow-up campaigns.<\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Create <strong>call lists<\/strong> based on stage, value, or engagement<\/li>\n<li>Flag <strong>stalled deals<\/strong> that haven\u2019t moved in weeks<\/li>\n<li>Filter your pipeline by <strong>industry, owner, or deal size<\/strong><\/li>\n<\/ul>\n<h2>FIND &amp; SEARCH: Locate key information in your prospect database<\/h2>\n<p>Need to build a targeted call list or flag promising leads for a campaign? FILTER helps you extract only the rows that match specific conditions, perfect for real-time segmentation.<\/p>\n<h3>FIND &amp; SEARCH<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=FIND(find_text, within_text, [start_at]) \u2014 Case-sensitive<\/li>\n<li>=SEARCH(find_text, within_text, [start_at]) \u2014 Case-insensitive<\/li>\n<\/ul>\n<p>For multiple keywords, use REGEXMATCH instead (see below). When working with text, wrap string conditions (e.g. &#8220;Qualified&#8221;) in <strong>quotation marks<\/strong>.<\/p>\n<p><strong>Sales example:<\/strong> Check if prospect titles indicate decision-making authority:<\/p>\n<pre class=\"codeblock\"><code>=IF(REGEXMATCH(LOWER(D3), \"director|vp|chief|ceo|manager\"), \"Decision Maker\", \"Influencer\")<\/code><\/pre>\n<p><em>This checks if column D (e.g. job title) contains keywords that typically indicate decision authority. LOWER() ensures the match works regardless of case<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/bceb8b85-2cd9-4cdd-bcf3-a117c24054c6.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Identify prospects mentioning specific pain points in notes<\/li>\n<li><a href=\"https:\/\/phantombuster.com\/automations\/toolbox\/3171\/domain-name-finder\" target=\"_blank\" rel=\"noopener noreferrer\">Extract domain names <\/a>from email addresses<\/li>\n<li>Check if company descriptions include target keywords<\/li>\n<li>Flag records containing specific information<\/li>\n<\/ul>\n<h2>FORECAST: Predict sales outcomes and closing probabilities<\/h2>\n<p>FORECAST helps you project future results based on existing data, perfect for sales predictions and pipeline analysis. Calculate future value of projected deals<\/p>\n<h3>FORECAST<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=FORECAST(x, known_y's, known_x's)<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Project monthly closing values based on historical performance:<\/p>\n<pre class=\"codeblock\"><code>=FORECAST(A10, B2:B9, A2:A9)<\/code><\/pre>\n<p><em>Calculate the future value of projected deals for the date in A10 based on historical values (B2:B9) from previous dates (A2:A9).<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/15816166-86d7-4676-ab0a-0c49f043d7e9.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Predict resource needs for upcoming quarters<\/li>\n<li>Forecast lead volume based on marketing activities<\/li>\n<li>Calculate net present value of large deals<\/li>\n<li>Estimate close dates for complex sales cycles<\/li>\n<li>Project territory performance against targets<\/li>\n<\/ul>\n<h2>IF, IFS &amp; IFERROR: Build lead scoring and qualification systems<\/h2>\n<p>These conditional functions let you return one value if true, another if false, to automate decisions in your sales process.<\/p>\n<h3>IF, IFS &amp; IFERROR<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=IF(logical_test, value_if_true, value_if_false) &#8211; Basic conditional<\/li>\n<li>=IFS(condition1, value1, condition2, value2, &#8230;) &#8211; Multiple conditions<\/li>\n<li>=IFERROR(value, value_if_error) &#8211; Handle errors gracefully<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Create a lead scoring system:<\/p>\n<pre class=\"codeblock\"><code>=IFS(\r\n    AND(D2=\"Enterprise\", J2&gt;100000), \"A-Priority\",\r\n    AND(D2=\"Enterprise\", J2&lt;=100000), \"B-Priority\",\r\n    AND(D2=\"Mid-Market\", J2&gt;50000), \"B-Priority\",\r\n    AND(D2=\"Mid-Market\", J2&lt;=50000), \"C-Priority\",\r\n    D2=\"SMB\", \"C-Priority\"\r\n)<\/code><\/pre>\n<p><em>Assigns <\/em><em>priority ratings<\/em><em> based on company type (D) and potential value (J)<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/ce93d2ec-6004-40db-aafa-1454123a669b.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Build logic for territory assignment<\/li>\n<li>Create deal stage advancement criteria<\/li>\n<li>Design automated qualification workflows<\/li>\n<li>Build custom status indicators for pipeline visualization<\/li>\n<\/ul>\n<h2>INDEX &amp; MATCH: Create flexible lookups across multiple data points<\/h2>\n<p>This powerful combination provides more flexible lookups than VLOOKUP, using both row and column cell references<\/p>\n<h3>INDEX &amp; MATCH<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=INDEX(range, MATCH(lookup_value, lookup_range, 0))<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Find the highest-performing sales rep for a specific industry:<\/p>\n<pre class=\"codeblock\"><code>=INDEX(C2:C100, MATCH(MAX(J2:J100), J2:J100, 0))<\/code><\/pre>\n<p><em>This formula looks at the Deal Value column (J), finds the max value, and returns the corresponding value from column C.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/8d2b4be5-ad7c-4136-ad99-26a52cc14076.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Create two-way verification systems for data accuracy<\/li>\n<li>Build complex dashboards with dynamic reference points<\/li>\n<li>Perform lookups based on multiple criteria<\/li>\n<li>Create custom territory assignment systems<\/li>\n<\/ul>\n<h2>IMPORTRANGE: Connect team data without disrupting individual Workflows<\/h2>\n<p>IMPORTRANGE lets you pull data from other spreadsheets, perfect for creating centralized dashboards while team members maintain their own sheets.<\/p>\n<h3>IMPORTRANGE<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=IMPORTRANGE(\"spreadsheet_url\", \"range_string\")<\/code><\/pre>\n<blockquote><p>\u26a0\ufe0f The first time you use IMPORTRANGE, Google Sheets will ask you to <strong>&#8220;Allow access&#8221;<\/strong> to connect the two files.<\/p><\/blockquote>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/70ae768c-3787-412d-9e8a-75e8d4a4c9ab.png\" \/><\/p>\n<p><strong>Sales example:<\/strong> Create a team dashboard pulling from individual rep spreadsheets:<\/p>\n<pre class=\"codeblock\"><code>=IMPORTRANGE(\"spreadsheet_url\", \"Sheet1!A1:L9\")<\/code><\/pre>\n<p><em>Imports data from the &#8220;Sheet1&#8221; tab, range A1:L9, from another spreadsheet using IMPORTRANGE().<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/29eb6af0-3301-4733-9623-181249202281.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Pull data from marketing campaigns into sales sheets<\/li>\n<li>Create management views without disrupting individual workflows<\/li>\n<li>Maintain separate territory sheets that feed into a master dashboard<\/li>\n<li>Connect lead generation data with sales activity tracking<\/li>\n<\/ul>\n<h2>LEFT, RIGHT &amp; MID: Extract and parse contact information efficiently<\/h2>\n<p>These text functions extract portions of text strings, perfect for standardizing and parsing inconsistent data.<\/p>\n<h3>LEFT, RIGHT &amp; MID<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=LEFT(text, num_chars) &#8211; Extracts characters from the start<\/li>\n<li>=RIGHT(text, num_chars) &#8211; Extracts characters from the end<\/li>\n<li>=MID(text, start_position, num_chars) &#8211; Extracts characters from the middle<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Extract area codes from phone numbers for territory mapping:<\/p>\n<pre class=\"codeblock\"><code>=IF(LEFT(G2,1)=\"(\", MID(G2,2,3), LEFT(G2,3))<\/code><\/pre>\n<p><em>Extracts the area code whether the format is (123)456-7890 or 123-456-7890<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/796f2b1f-7822-444d-a14d-da2da6bd978c.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Parse names from inconsistent formats<\/li>\n<li>Extract company identifiers from product codes<\/li>\n<li>Standardize address components<\/li>\n<li>Split domain names from email addresses<\/li>\n<\/ul>\n<h2>LEN: Verify the completeness of your prospect records<\/h2>\n<p>LEN helps you check text length, which is useful for verifying that data meets minimum requirements or identifying <a href=\"https:\/\/phantombuster.com\/automations\/ai\/1333223865797404\/ai-linkedin-profile-enricher\" target=\"_blank\" rel=\"noopener noreferrer\">fields that need enrichment<\/a>.<\/p>\n<h3>LEN<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=LEN(text)<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Flag incomplete contact records that need enrichment:<\/p>\n<pre class=\"codeblock\"><code>=IF(LEN(F2)&lt;15, \"Needs Enrichment\", \"OK\")<\/code><\/pre>\n<p><em>Marks records where the data in column D (e.g., company description) is too short<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/7ec3b56f-4614-4dc8-95d6-5f46b3d7ff3a.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Verify phone numbers have the correct length<\/li>\n<li>Check that addresses meet minimum completeness<\/li>\n<li>Identify overly brief notes that need expansion<\/li>\n<li>Flag prospect records needing enrichment<\/li>\n<\/ul>\n<h2>MAX &amp; MIN: Identify your best opportunities and biggest challenges<\/h2>\n<p>These functions find the <strong>maximum value<\/strong> and <strong>minimum value<\/strong> in a range, perfect for identifying outliers and setting benchmarks.<\/p>\n<h3>MAX &amp; MIN<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=MAX(number1, [number2], &#8230;) &#8211; Returns the highest value<\/li>\n<li>=MIN(number1, [number2], &#8230;) &#8211; Returns the smallest value<\/li>\n<\/ul>\n<pre class=\"codeblock\"><code>=MAX(E2:E100)<\/code><\/pre>\n<p><em>Returns the highest value from column E (deal values)<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Find your longest sales cycle to identify process issues<\/li>\n<li>Identify your shortest time-to-close for best practice analysis<\/li>\n<li>Set benchmarks for performance tracking<\/li>\n<li>Highlight extreme values for special attention or analysis<\/li>\n<li>Use ABS to compare absolute value of gains\/losses between periods<\/li>\n<\/ul>\n<h2>NETWORKDAYS: Calculate realistic sales cycle timeframes<\/h2>\n<p>NETWORKDAYS calculates working days between dates, giving you more accurate sales cycle projections by excluding weekends.<\/p>\n<h3>NETWORKDAYS<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=NETWORKDAYS(start_date, end_date, [holidays])<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Calculate actual working days in your sales cycle:<\/p>\n<pre class=\"codeblock\"><code>=NETWORKDAYS(C2, D2)<\/code><\/pre>\n<p><em>Calculates working days between opportunity creation (C2) and the close date (D2)<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Project realistic closing timeframes<\/li>\n<li>Set more accurate follow-up schedules<\/li>\n<li>Calculate average working days to close by deal type<\/li>\n<li>Measure response time in working days rather than calendar days<\/li>\n<\/ul>\n<h2>PIVOT TABLES: Analyze your sales performance from multiple Angles<\/h2>\n<p>While not a formula, pivot tables are essential for data analysis and sales analytics.<\/p>\n<p><strong>Sales example:<\/strong> Analyze closing rates by lead source and sales rep:<\/p>\n<ol>\n<li>Create a pivot table from your data by selecting your data, clicking on &#8220;Insert.&#8221; and then will choose &#8220;Pivot table.&#8221;<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/7b5ffa0e-97a0-46a5-ba3c-8df15c120c0e.png\" \/><\/p>\n<ol>\n<li>Add &#8220;Sales Rep&#8221; to Rows<\/li>\n<li>Add &#8220;Lead Source&#8221; to Columns<\/li>\n<li>Add &#8220;Deal Status&#8221; to Filters and filter for &#8220;Closed Won&#8221;<\/li>\n<li>Add &#8220;Deal Value&#8221; to Values<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/617caceb-2895-4d10-b259-3632c914aaff.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Identify performance patterns across multiple dimensions<\/li>\n<li>Visualize territory performance by product and industry<\/li>\n<li>Analyze seasonal trends in sales metrics<\/li>\n<li>Compare team performance across different criteria<\/li>\n<\/ul>\n<h2>QUERY: Create custom sales reports with multiple conditions<\/h2>\n<p>QUERY lets you use SQL-like commands to manipulate data, perfect for creating flexible reports from complex sales data.<\/p>\n<h3>QUERY<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=QUERY(data, query, [headers])<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Create a report of high-value opportunities closing this quarter:<\/p>\n<pre class=\"codeblock\"><code>=QUERY(A1:J9, \r\n\"SELECT A, B, C, H, I \r\n WHERE H &gt; 50000 \r\n   AND I &gt;= date '\"&amp;TEXT(EOMONTH(TODAY(), -2)+1, \"yyyy-MM-dd\")&amp;\"' \r\n   AND I &lt;= date '\"&amp;TEXT(EOMONTH(TODAY(), 0), \"yyyy-MM-dd\")&amp;\"' \r\n ORDER BY H DESC\", \r\n1)<\/code><\/pre>\n<p><em>Returns first name, last name, company, deal value, and last contact date for all opportunities with a deal value over $50k, closing within the current quarter.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/c9ba071f-f8a3-46a9-9fe0-abdca58c5adc.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Build flexible dashboards that respond to changing criteria<\/li>\n<li>Create automated weekly reports for management review<\/li>\n<li>Generate territory-specific analyses on demand<\/li>\n<li>Perform complex filtering operations based on multiple criteria<\/li>\n<\/ul>\n<h2>REGEXMATCH: Categorize prospects using pattern recognition<\/h2>\n<p>REGEXMATCH function uses regular expressions to identify patterns in text, perfect for advanced categorization and data cleaning.<\/p>\n<h3>REGEXMATCH<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=REGEXMATCH(text, regular_expression)<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Categorize prospects based on email domain patterns:<\/p>\n<pre class=\"codeblock\"><code>=IF(REGEXMATCH(E2, \".(edu|gov)$\"), \"Public Sector\", IF(REGEXMATCH(E2, \".co.uk$\"), \"UK\", \"Commercial\"))<\/code><\/pre>\n<p><em>Categorizes email addresses ending in .edu or .gov as &#8220;Public Sector&#8221;, .<\/em><a href=\"http:\/\/co.uk\" target=\"_blank\" rel=\"noopener noreferrer\"><em>co.uk<\/em><\/a><em> as &#8220;UK&#8221;, and everything else as &#8220;Commercial&#8221;<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Clean and standardize company names<\/li>\n<li>Identify industry segments based on terminology in descriptions<\/li>\n<li>Categorize job titles into management levels<\/li>\n<li>Flag specific keywords in prospect communication<\/li>\n<\/ul>\n<h2>SORT: Prioritize your prospects and opportunities automatically<\/h2>\n<p>SORT arranges data based on one or more columns, helping you create prioritized lists for <a href=\"https:\/\/phantombuster.com\/automations\/linkedin\/4545709793535249\/linkedin-outreach\" target=\"_blank\" rel=\"noopener noreferrer\">outreach and follow-up.<\/a><\/p>\n<h3>SORT<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...])<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Create a prioritized call list based on deal value and recency:<\/p>\n<pre class=\"codeblock\"><code>=SORT(A2:E50, 5, FALSE, 4, TRUE)<\/code><\/pre>\n<p><em>Sorts data by column E (value) in descending order, then by column D (last contact) in ascending order<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Organize prospects by engagement score<\/li>\n<li>Prioritize daily outreach activities<\/li>\n<li>Rank opportunities by close probability<\/li>\n<li>Create call lists based on multiple priority factors<\/li>\n<\/ul>\n<h2>SPARKLINE: Visualize deal progress and trends directly in your spreadsheet<\/h2>\n<p>SPARKLINE creates mini-charts inside cells, allowing you to see trends alongside your data without creating separate charts.<\/p>\n<h3>SPARKLINE<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=SPARKLINE(data, [options])<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Show monthly progress toward sales targets:<\/p>\n<pre class=\"codeblock\"><code>=SPARKLINE(B2:M2, {\"charttype\",\"bar\")<\/code><\/pre>\n<p><em>Creates a bar chart showing monthly sales.<\/em><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/bb729b3e-5388-4717-87fe-959f2887dda1.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Create mini trend visualizations of deal progress<\/li>\n<li>Show velocity metrics in-line with prospect data<\/li>\n<li>Visualize week-over-week activity metrics<\/li>\n<li>Display historical win rates alongside current opportunities<\/li>\n<\/ul>\n<h2>SUBSTITUTE: Clean and standardize imported contact data<\/h2>\n<p>SUBSTITUTE replaces specific text within strings (text data), perfect for cleaning and standardizing inconsistent data formats.<\/p>\n<h3>SUBSTITUTE<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=SUBSTITUTE(text, old_text, new_text, [instance_num])<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Standardize phone number formats:<\/p>\n<pre class=\"codeblock\"><code>=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, \"(\", \"\"), \")\", \"\"), \"-\", \"\")<\/code><\/pre>\n<p><em>Removes parentheses and dashes from phone numbers to create a standardized format.<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Clean formatting issues in imported prospect data<\/li>\n<li>Standardize inconsistent entry formats<\/li>\n<li>Normalize company name variations<\/li>\n<li>Replace abbreviations with full terms for consistency<\/li>\n<\/ul>\n<h2>SUM, SUMIF &amp; SUMIFS: Calculate pipeline values and performance totals<\/h2>\n<p>These functions add up values based on various criteria, making them ideal for pipeline analysis and performance tracking.<\/p>\n<h3>SUM, SUMIF &amp; SUMIFS<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=SUM(number1, [number2], &#8230;) &#8211; Adds all values<\/li>\n<li>=SUMIF(range, criteria, [sum_range]) &#8211; Adds values based on a condition<\/li>\n<li>=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]&#8230;) &#8211; Adds values based on multiple conditions<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Calculate pipeline value by closing month:<\/p>\n<pre class=\"codeblock\"><code>=SUMIFS(F2:F100, E2:E100, \"Qualified\", D2:D100, \"&gt;=\"&amp;DATE(YEAR(TODAY()),MONTH(TODAY()),1), D2:D100, \"&lt;\"&amp;EOMONTH(TODAY(),0)+1)<\/code><\/pre>\n<p><em>Sums values from column F where status is &#8220;Qualified&#8221; (column E) and close date (column D) is in the current month.<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Track activity metrics by sales rep<\/li>\n<li>Measure campaign performance by lead source<\/li>\n<li>Calculate pipeline value by stage and territory<\/li>\n<li>Analyze conversion values across different segments<\/li>\n<\/ul>\n<h2>TRIM: Prepare contact data for matching and analysis<\/h2>\n<p>TRIM removes extra spaces from text, fixing common issues with imported or manually entered data.<\/p>\n<h3>TRIM<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=TRIM(text)<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Clean up company names for consistent matching:<\/p>\n<pre class=\"codeblock\"><code>=TRIM(C2)<\/code><\/pre>\n<p><em>Removes any leading, trailing, or extra spaces in the company name.<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Clean up imported contact data with extra spaces<\/li>\n<li>Prepare data for matching operations<\/li>\n<li>Fix common formatting issues from copy-paste operations<\/li>\n<li>Standardize text entries for consistent analysis<\/li>\n<\/ul>\n<h2>UNIQUE: Remove Duplicate Contacts and Companies From Your Database<\/h2>\n<p>UNIQUE extracts distinct values from a range, helping you identify unique entries and remove duplicates.<\/p>\n<h3>UNIQUE<strong> syntax:<\/strong><\/h3>\n<pre class=\"codeblock\"><code>=UNIQUE(range)<\/code><\/pre>\n<p><strong>Sales example:<\/strong> Create a list of unique companies from your contact database:<\/p>\n<pre class=\"codeblock\"><code>=UNIQUE(C2:C200)<\/code><\/pre>\n<p><em>Returns only unique company names from column C<\/em><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Remove duplicate contacts from prospecting lists<\/li>\n<li>Create distinct company lists from contact databases<\/li>\n<li>Identify unique lead sources for analysis<\/li>\n<li>Extract unique values for dropdown lists in data validation<\/li>\n<\/ul>\n<h2>VLOOKUP, HLOOKUP &amp; XLOOKUP: Match and Enrich Your Prospect Information<\/h2>\n<p>These lookup functions help you find and retrieve related information across different datasets, making them ideal for data enrichment.<\/p>\n<h3>VLOOKUP, HLOOKUP &amp; XLOOKUP<strong> syntax:<\/strong><\/h3>\n<ul>\n<li>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) &#8211; Vertical lookup<\/li>\n<li>=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) &#8211; Horizontal lookup<\/li>\n<li>=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) &#8211; Most flexible lookup<\/li>\n<\/ul>\n<p><strong>Sales example:<\/strong> Enrich contact records with company information:<\/p>\n<pre class=\"codeblock\"><code>=VLOOKUP(C2, Companies!$A$2:$C$9, 2, FALSE<\/code><\/pre>\n<p><em>Looks up the company name in C2 by matching it against the <\/em><strong><em>first column<\/em><\/strong><em> of the range Companies!$A$2:$C$9 in the <\/em><strong><em>Companies tab<\/em><\/strong><em>, and returns the corresponding <\/em><strong><em>industry<\/em><\/strong><em> from column 2.<\/em><\/p>\n<p><strong>Note:<\/strong> VLOOKUP always searches the <strong>first column<\/strong> of the range for a match\u2014so in this case, the company names must be listed in column A of the Companies sheet.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/bcfc10ad-ef5d-4c68-890a-09e272445a98.png\" \/><\/p>\n<p><strong>Additional uses:<\/strong><\/p>\n<ul>\n<li>Match inbound leads to existing accounts<\/li>\n<li>Pull in additional contact details from a master database<\/li>\n<li>Connect CRM IDs with internal tracking systems<\/li>\n<li>Link product details to opportunity records<\/li>\n<\/ul>\n<h2>Conditional formatting: Visualize your sales data for quick Insights<\/h2>\n<p>Conditional formatting transforms your sales data into a visual dashboard without creating separate charts. This powerful feature helps you identify patterns, spot warm leads, and flag items requiring attention.<\/p>\n<h3>Highlight deals that haven&#8217;t moved in 30+ days<\/h3>\n<p><strong>How to set it up:<\/strong><\/p>\n<ol>\n<li>Select your opportunity data range<\/li>\n<li>Go to Format &gt; Conditional formatting<\/li>\n<li>Choose &#8220;Custom formula is&#8221; from the dropdown<\/li>\n<li>Enter: =TODAY()-$E2&gt;30 (assuming E2 contains the &#8220;Last Updated&#8221; date)<\/li>\n<li>Set the formatting style (red background with white text works well)<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/48327ea3-2f3f-47ef-b517-f3eb1b2a27b8.png\" \/><\/p>\n<p>This visually flags any deals that haven&#8217;t seen activity in over a month, preventing opportunities from falling through the cracks.<\/p>\n<h3>Color-code prospects based on lead score or engagement level<\/h3>\n<p><strong>How to set it up:<\/strong><\/p>\n<ol>\n<li>Select your lead score column<\/li>\n<li>Go to <strong>Format<\/strong> &gt; <strong>Conditional formatting<\/strong><\/li>\n<li>Choose &#8220;Color scale&#8221;<\/li>\n<li>Select a green-to-red scale (high scores green, low scores red)<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/47ad1317-b29b-41a4-9f49-b0d61fdf34ae.png\" \/><\/p>\n<p>Alternatively, create custom rules for score ranges:<\/p>\n<ol>\n<li>Choose &#8220;Custom formula is&#8221;<\/li>\n<li>For A-leads: =$F2&gt;=80 with green background<\/li>\n<li>For B-leads: =AND($F2&gt;=50,$F2&lt;80) with yellow background<\/li>\n<li>For C-leads: =$F2&lt;50 with red background<\/li>\n<\/ol>\n<p>This creates an instant visual prioritization system for your prospect list.<\/p>\n<h3>Create heat maps of sales performance by rep or territory<\/h3>\n<p><strong>How to set it up:<\/strong><\/p>\n<ol>\n<li>Select your data range (reps in rows, months in columns, values in cells)<\/li>\n<li>Go to <strong>Format<\/strong> &gt; <strong>Conditional formatting<\/strong><\/li>\n<li>Choose &#8220;Color scale&#8221;<\/li>\n<li>Select a white-to-blue scale for a professional look<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/c45ca3e0-2387-40a0-9e59-bc898fd01a67.png\" \/><\/p>\n<p>This instantly shows which reps are performing well (darker cells) and who might need coaching (lighter cells).<\/p>\n<h2>Google Sheets basics every sales rep should know<\/h2>\n<h3>Best practices for organizing sales tracking spreadsheets<\/h3>\n<p>To manage your sales data efficiently, follow these core tips:<\/p>\n<ul>\n<li><strong>Use separate sheets<\/strong> to organize and store data for prospects, pipeline, closed deals, and dashboards.<\/li>\n<li><strong>Keep column names consistent<\/strong> across tabs (name, company, status, etc.).<\/li>\n<li><strong>Freeze headers and key columns<\/strong> to keep key information visible while scrolling.<\/li>\n<li><strong>Create reusable templates<\/strong> and duplicate them for each new month or quarter.<\/li>\n<\/ul>\n<h3>Formatting cells for better sales data visualization<\/h3>\n<table>\n<colgroup>\n<col \/>\n<col \/><\/colgroup>\n<tbody>\n<tr>\n<th colspan=\"1\" rowspan=\"1\"><strong>Formatting aspect<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Best practices<\/strong><\/th>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"3\"><strong>Number Formats<\/strong><\/td>\n<td colspan=\"1\" rowspan=\"1\">Currency for deal values: Format &gt; Number &gt; Currency<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Percentages for probabilities: Format &gt; Number &gt; Percent<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Custom number format for phone numbers: Format &gt; Number &gt; More Formats &gt; Custom number format: (###) ###-####<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"3\"><strong>Text Alignment<\/strong><\/td>\n<td colspan=\"1\" rowspan=\"1\">Left-align text and headers<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Right-align number values<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Center status indicators<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"3\"><strong>Font Choices<\/strong><\/td>\n<td colspan=\"1\" rowspan=\"1\">11pt for most data<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">12pt bold for headers<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Use color sparingly (for status or highlighting only)<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"2\"><strong>Column Width Optimization<\/strong><\/td>\n<td colspan=\"1\" rowspan=\"1\">Double-click between column headers to auto-resize<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Preset widths for standard columns (names, companies, etc.)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>How to use data validation for consistent lead entry and categorization<\/h3>\n<p>Data validation ensures your team enters standardized information, making analysis easier and more accurate.<\/p>\n<p>To implement data validation, select your column, go to <strong>Data &gt; Data validation<\/strong>, then choose either:<\/p>\n<ul>\n<li><strong>Dropdown (from a range)<\/strong> to reference a column elsewhere (e.g., a list of deal stages)<\/li>\n<li>or <strong>Dropdown<\/strong> to manually enter predefined values (like \u201cQualified\u201d, \u201cContacted\u201d, etc.)<\/li>\n<\/ul>\n<p>You can also enable the dropdown arrow and optional help text.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/e27deb6a-22f2-4826-ae6d-5b1be4362441.png\" \/><\/p>\n<h4>Sales-specific validation examples<\/h4>\n<ul>\n<li><strong>Lead status<\/strong>: Prospect, Qualified, Proposal, Negotiation, Closed Won, Closed Lost<\/li>\n<li><strong>Lead source:<\/strong> Referral, LinkedIn, Website, Event, Cold Call, Partner<\/li>\n<li><strong>Priority<\/strong>: A, B, C<\/li>\n<li><strong>Industry<\/strong>: Technology, Healthcare, Finance, Manufacturing, Retail, etc.<\/li>\n<\/ul>\n<p>This ensures data consistency, prevents typos, and makes filtering much more reliable.<\/p>\n<h3>How to set up protected ranges for sensitive sales information<\/h3>\n<p><strong>How to protect sensitive data in Google Sheets:<\/strong> Select the cells you want to protect, right-click and choose \u201cView more cell actions\u201d &gt; \u201cProtect range.\u201d Then adjust editing permissions to restrict access.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/images.surferseo.art\/f8d2c3b3-4c64-49b7-816c-7252f6a46ffa.png\" \/><\/p>\n<h4>Sales information worth protecting<\/h4>\n<ul>\n<li>Formulas calculating commissions<\/li>\n<li>Target and quota information<\/li>\n<li>Customer discount rates<\/li>\n<li>Data validation ranges<\/li>\n<li>Key dashboard calculations<\/li>\n<\/ul>\n<p>This maintains formula integrity and prevents accidental edits to important fields.<\/p>\n<h3>Other useful Google Sheets functions &amp; tips for sales teams<\/h3>\n<p>Whether you&#8217;re new to Google Sheets or looking to push its advanced features, there are plenty of lesser-known formulas and options that can enhance your data set and streamline daily operations.<\/p>\n<p>Use these to improve your workflow:<\/p>\n<ul>\n<li>Use <strong>COLUMN() <\/strong>to return the column letter, or ROW() for the row number.<\/li>\n<li><strong>CELL()<\/strong> returns the starting cell reference or cell range properties.<\/li>\n<li>Apply <strong>ROUND() <\/strong>or format options to control decimal value, decimal places, or simplify to the nearest integer of a specified number of digits.<\/li>\n<li><strong>ISBLANK() <\/strong>flags empty cells while<strong> COUNTA() <\/strong>detects non-empty cells.<\/li>\n<li>Conditional formulas like <strong>IFS()<\/strong> or <strong>SWITCH()<\/strong> help when logic evaluates multiple conditions or filters by a specified range.<\/li>\n<li>Apply finance formulas like <strong>PMT() <\/strong>or <strong>IPMT()<\/strong> to calculate interest payment, periodic payment, periodic interest, and payment periods.<\/li>\n<li>Use <strong>GOOGLEFINANCE()<\/strong> to export historical securities information from Google Finance or create lightweight financial reports.<\/li>\n<li>Use <strong>RAND() <\/strong>or <strong>RANDBETWEEN()<\/strong> to generate a random number for simulations or testing.<\/li>\n<li>Use <strong>BASE(number, base)<\/strong> to convert numbers into a specified base, such as binary or hexadecimal.<\/li>\n<li>Use math functions like<strong> ABS()<\/strong>, <strong>SQRT()<\/strong> (for square root), or <strong>POWER()<\/strong> to perform quick calculations.<\/li>\n<li>Access the menu bar to create drop-downs, format cells, or automate with Google Workspace add-ons.<\/li>\n<\/ul>\n<p>These tips bridge the gap between <strong>Excel basics<\/strong> and more powerful setups, even if you&#8217;re used to <strong>Microsoft Excel<\/strong>.<\/p>\n<h2>Google Sheets keyboard shortcuts for sales productivity<\/h2>\n<p>Speed up your daily sales data work with these time-saving shortcuts. Mastering these can significantly boost sales productivity and improve overall sales efficiency by saving hours of administrative time each week.<\/p>\n<h3>Navigation shortcuts to move efficiently through prospect lists<\/h3>\n<table>\n<colgroup>\n<col \/>\n<col \/>\n<col \/><\/colgroup>\n<tbody>\n<tr>\n<th colspan=\"1\" rowspan=\"1\"><strong>Shortcut<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Action<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Sales use case<\/strong><\/th>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Home<\/td>\n<td colspan=\"1\" rowspan=\"1\">Jump to the beginning of the sheet<\/td>\n<td colspan=\"1\" rowspan=\"1\">Return to top of prospect list<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + End<\/td>\n<td colspan=\"1\" rowspan=\"1\">Jump to the last cell with content<\/td>\n<td colspan=\"1\" rowspan=\"1\">Skip to the end of your data<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Arrow Key<\/td>\n<td colspan=\"1\" rowspan=\"1\">Jump to the edge of a data region<\/td>\n<td colspan=\"1\" rowspan=\"1\">Move between sections quickly<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Alt + Down<\/td>\n<td colspan=\"1\" rowspan=\"1\">Open the dropdown menu<\/td>\n<td colspan=\"1\" rowspan=\"1\">Access lead status options<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Page Down\/Up<\/td>\n<td colspan=\"1\" rowspan=\"1\">Switch between sheets<\/td>\n<td colspan=\"1\" rowspan=\"1\">Move between pipeline stages<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + G<\/td>\n<td colspan=\"1\" rowspan=\"1\">Go to a specific cell<\/td>\n<td colspan=\"1\" rowspan=\"1\">Jump to specific prospect record<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + Arrow<\/td>\n<td colspan=\"1\" rowspan=\"1\">Select the edge of the data<\/td>\n<td colspan=\"1\" rowspan=\"1\">Select an entire prospect record<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Editing shortcuts for quick data updates<\/h3>\n<table>\n<colgroup>\n<col \/>\n<col \/>\n<col \/><\/colgroup>\n<tbody>\n<tr>\n<th colspan=\"1\" rowspan=\"1\"><strong>Shortcut<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Action<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Sales use case<\/strong><\/th>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + ;<\/td>\n<td colspan=\"1\" rowspan=\"1\">Insert current date<\/td>\n<td colspan=\"1\" rowspan=\"1\">Log contact dates instantly<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">F2<\/td>\n<td colspan=\"1\" rowspan=\"1\">Edit cell<\/td>\n<td colspan=\"1\" rowspan=\"1\">Quick update to notes or status<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Enter<\/td>\n<td colspan=\"1\" rowspan=\"1\">Stay in the current cell after entry<\/td>\n<td colspan=\"1\" rowspan=\"1\">Update multiple fields without clicking<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Shift + Enter<\/td>\n<td colspan=\"1\" rowspan=\"1\">Complete the entry and move up<\/td>\n<td colspan=\"1\" rowspan=\"1\">Work backwards through a list<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + K<\/td>\n<td colspan=\"1\" rowspan=\"1\">Insert hyperlink<\/td>\n<td colspan=\"1\" rowspan=\"1\">Add links to LinkedIn profiles or proposals<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Alt + V<\/td>\n<td colspan=\"1\" rowspan=\"1\">Paste special<\/td>\n<td colspan=\"1\" rowspan=\"1\">Paste only values from CRM without formatting<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Alt + Enter<\/td>\n<td colspan=\"1\" rowspan=\"1\">Add a line break within a cell<\/td>\n<td colspan=\"1\" rowspan=\"1\">Format detailed notes cleanly<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Formatting shortcuts for consistent sales reporting<\/h3>\n<table>\n<colgroup>\n<col \/>\n<col \/>\n<col \/><\/colgroup>\n<tbody>\n<tr>\n<th colspan=\"1\" rowspan=\"1\"><strong>Shortcut<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Action<\/strong><\/th>\n<th colspan=\"1\" rowspan=\"1\"><strong>Sales use case<\/strong><\/th>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + B<\/td>\n<td colspan=\"1\" rowspan=\"1\">Bold<\/td>\n<td colspan=\"1\" rowspan=\"1\">Highlight key prospects<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + 1<\/td>\n<td colspan=\"1\" rowspan=\"1\">Number format<\/td>\n<td colspan=\"1\" rowspan=\"1\">Standardize number display<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + 4<\/td>\n<td colspan=\"1\" rowspan=\"1\">Currency format<\/td>\n<td colspan=\"1\" rowspan=\"1\">Quick format deal values<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + 5<\/td>\n<td colspan=\"1\" rowspan=\"1\">Percentage format<\/td>\n<td colspan=\"1\" rowspan=\"1\">Format conversion rates<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Alt + H + H<\/td>\n<td colspan=\"1\" rowspan=\"1\">Fill color<\/td>\n<td colspan=\"1\" rowspan=\"1\">Status highlighting<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + F<\/td>\n<td colspan=\"1\" rowspan=\"1\">Open format cells dialog<\/td>\n<td colspan=\"1\" rowspan=\"1\">Advanced formatting options<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Space<\/td>\n<td colspan=\"1\" rowspan=\"1\">Select entire column<\/td>\n<td colspan=\"1\" rowspan=\"1\">Format all status indicators at once<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Formula shortcuts to speed up analysis<\/h3>\n<table>\n<colgroup>\n<col \/>\n<col \/>\n<col \/><\/colgroup>\n<tbody>\n<tr>\n<th colspan=\"1\" rowspan=\"1\">Shortcut<\/th>\n<th colspan=\"1\" rowspan=\"1\">Action<\/th>\n<th colspan=\"1\" rowspan=\"1\">Sales Use Case<\/th>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">=<\/td>\n<td colspan=\"1\" rowspan=\"1\">Start formula<\/td>\n<td colspan=\"1\" rowspan=\"1\">Begin any calculation<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">F4<\/td>\n<td colspan=\"1\" rowspan=\"1\">Toggle absolute\/relative references<\/td>\n<td colspan=\"1\" rowspan=\"1\">Lock territory or period references<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + Enter<\/td>\n<td colspan=\"1\" rowspan=\"1\">Enter array formula<\/td>\n<td colspan=\"1\" rowspan=\"1\">Apply lead scoring to multiple prospects<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Alt + =<\/td>\n<td colspan=\"1\" rowspan=\"1\">AutoSum<\/td>\n<td colspan=\"1\" rowspan=\"1\">Quickly total your pipeline<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + ~<\/td>\n<td colspan=\"1\" rowspan=\"1\">Show formulas<\/td>\n<td colspan=\"1\" rowspan=\"1\">Debug your sales calculations<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Ctrl + Shift + U<\/td>\n<td colspan=\"1\" rowspan=\"1\">Expand formula bar<\/td>\n<td colspan=\"1\" rowspan=\"1\">Write complex prospect analysis formulas<\/td>\n<\/tr>\n<tr>\n<td colspan=\"1\" rowspan=\"1\">Shift + F3<\/td>\n<td colspan=\"1\" rowspan=\"1\">Open function wizard<\/td>\n<td colspan=\"1\" rowspan=\"1\">Get help with unfamiliar functions<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Importing and enriching sales data inside Google Sheets<\/h2>\n<p>Transform basic contact lists into rich prospect databases and keep your pipeline data fresh with streamlined enrichment techniques.<\/p>\n<h3>Bringing LinkedIn search results into your prospect sheets<\/h3>\n<p>You don\u2019t need to manually copy results from LinkedIn into your spreadsheet. With PhantomBuster, you can pull them in automatically. Just run a LinkedIn search using the filters you already use \u2014 job title, location, industry \u2014 and the <a href=\"https:\/\/phantombuster.com\/automations\/linkedin\/3149\/linkedin-search-export\" target=\"_blank\" rel=\"noopener noreferrer\">LinkedIn Search Export<\/a> automation grabs the matching profiles for you.<\/p>\n<p>The data goes straight into Google Sheets, clean and ready to use. You can even set it to update on a schedule, so your prospect list stays fresh without you having to think about it.<\/p>\n<p>If you want to go further, you can enrich each profile with job details, emails or company info using the <a href=\"https:\/\/phantombuster.com\/automations\/linkedin\/5589386912058181\/linkedin-profile-scraper\" target=\"_blank\" rel=\"noopener noreferrer\">LinkedIn Profile Scraper<\/a>. It\u2019s a simple way to take what LinkedIn gives you and turn it into something actually usable.<\/p>\n<p>Phantombuster provides powerful prospecting automation tools to extract and import LinkedIn search results directly into Google Sheets, creating fresh prospect lists with minimal manual effort.<\/p>\n<h3>Enriching basic contact lists with detailed professional information<\/h3>\n<p>Once your LinkedIn search results are in Google Sheets, you can enrich them with professional context to build a truly usable prospect list. Instead of working with just names and companies, you\u2019ll get key insights like job titles, work experience, skills, and company details, all pulled automatically.<\/p>\n<p>To do that, connect your sheet to the <a href=\"https:\/\/phantombuster.com\/automations\/linkedin\/5589386912058181\/linkedin-profile-scraper\" target=\"_blank\" rel=\"noopener noreferrer\">LinkedIn Profile Scraper<\/a> automation. It pulls detailed information for each contact in bulk, so you can qualify leads, segment faster, and prep outreach without manual research. This step turns your list into a proper lead database, ready for scoring, routing, or messaging.<\/p>\n<p>If you&#8217;re starting with an existing CRM or event list instead of a LinkedIn export, no problem. Use the <a href=\"https:\/\/phantombuster.com\/automations\/linkedin\/4015\/linkedin-profile-url-finder\" target=\"_blank\" rel=\"noopener noreferrer\">LinkedIn Profile URL Finder<\/a> to match those contacts to their LinkedIn profiles before enriching. That way, any list becomes a launchpad.<\/p>\n<h2>FAQ: Google Sheets for sales teams<\/h2>\n<h3>How to share prospect sheets securely<\/h3>\n<p><strong>Steps:<\/strong> Click the <strong>Share<\/strong> button at the top-right of your Google Sheet. Add your teammates&#8217; email addresses to invite them. Set their permissions according to the level of access you want to grant: <strong>Editor<\/strong> can make changes, <strong>Commenter<\/strong> can leave feedback, and <strong>Viewer<\/strong> can only view the file.<\/p>\n<p><strong>Security tips:<\/strong> To keep your data safe, use <strong>&#8220;Restricted&#8221; access<\/strong> rather than allowing <strong>&#8220;Anyone with the link&#8221; <\/strong>to access the sheet. Consider adding <strong>expiration dates<\/strong> for temporary access to limit how long someone can view or edit the document. Use <strong>protected ranges<\/strong> to safeguard sensitive fields from accidental changes. Finally, regularly review and update access permissions to maintain control over who can view or edit your data.<\/p>\n<h3>How to use ChatGPT inside Google Sheets<\/h3>\n<p><strong>What to do:<\/strong><\/p>\n<ul>\n<li>Install a <strong>ChatGPT Sheets Add-on<\/strong><\/li>\n<li>Go to <strong>Extensions &gt; [Add-on Name]<\/strong><\/li>\n<li>Use prompts like:\n<ul>\n<li>=GPT(&#8220;Write a cold email for &#8221; &amp; A2)<\/li>\n<li>=GPT(&#8220;Analyze objection: &#8221; &amp; D2)<\/li>\n<li>=GPT(&#8220;Give 3 pain points for a &#8221; &amp; C2 &amp; &#8221; in &#8221; &amp; D2)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Perfect for quick outreach, call recaps, or lead insights\u2014without leaving Sheets.<\/p>\n<h3>How to track the version history of Google Sheets data<\/h3>\n<p><strong>Steps:<\/strong> To track the version history of your Google Sheets data, go to <strong>File<\/strong> &gt; <strong>Version History<\/strong>&gt; <strong>See Version History<\/strong>. From there, you can view edits by user and date, and restore old versions as needed.<\/p>\n<h3>How to connect Google Sheets to your CRM<\/h3>\n<table class=\"t1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p1\"><b>CRM Platform<\/b><b><\/b><\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p1\"><b>Steps to integrate with Google Sheets<\/b><b><\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\"><b>Salesforce<\/b><b><\/b><\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<ol data-pm-slice=\"3 3 [&quot;table&quot;,{&quot;id&quot;:&quot;a7039dbd-5a1f-48f7-ac35-531f04781506&quot;},&quot;tableRow&quot;,{},&quot;tableCell&quot;,{&quot;colspan&quot;:1,&quot;rowspan&quot;:3,&quot;colwidth&quot;:null}]\">\n<li>Install <strong>Salesforce Connector<\/strong><\/li>\n<li>Sync key fields<\/li>\n<li>\n<p data-pm-slice=\"1 1 [&quot;table&quot;,{&quot;id&quot;:&quot;a7039dbd-5a1f-48f7-ac35-531f04781506&quot;},&quot;tableRow&quot;,{},&quot;tableCell&quot;,{&quot;colspan&quot;:1,&quot;rowspan&quot;:3,&quot;colwidth&quot;:null},&quot;orderedList&quot;,{&quot;id&quot;:&quot;61823726-8d48-4541-9c64-a892c333ea31&quot;,&quot;start&quot;:1},&quot;listItem&quot;,{}]\">Match views with reports<\/p>\n<\/li>\n<\/ol>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\"><strong>HubSpot<\/strong><\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<ol>\n<li>Install <strong>HubSpot for Google Workspace<\/strong><\/li>\n<li>Map columns<\/li>\n<li>Set data refresh schedules<\/li>\n<\/ol>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\"><b>Other options<\/b><b><\/b><\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<ul>\n<li class=\"p2\">Use Zapier or Make<\/li>\n<li class=\"p2\">Connect to CRM APIs with IMPORTDATA<\/li>\n<li class=\"p2\">Build custom logic with Apps Script<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Looking for the ultimate Google Sheets reference guide specifically designed for sales professionals? This Google Sheets cheat sheet covers all the essential formulas and features you need to manage prospects, track your pipeline, and analyze sales performance\u2014all tailored to real-world sales scenarios. For a complete reference of all Google Sheets functions, you can also check [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":4900,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[31],"tags":[38,39],"class_list":["post-4355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-outbound-sales","tag-guides","tag-save-time"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &amp; Enrich Your Pipeline - PhantomBuster Blog<\/title>\n<meta name=\"description\" content=\"Learn the best keyboard shortcuts, Google Sheets functions, and toolbars to transform data inside your Sheet.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &amp; Enrich Your Pipeline - PhantomBuster Blog\" \/>\n<meta property=\"og:description\" content=\"Learn the best keyboard shortcuts, Google Sheets functions, and toolbars to transform data inside your Sheet.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"PhantomBuster Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-15T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-11T12:43:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Phantom Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Phantom Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\"},\"author\":{\"name\":\"Phantom Team\",\"@id\":\"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16\"},\"headline\":\"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &#038; Enrich Your Pipeline\",\"datePublished\":\"2023-05-15T00:00:00+00:00\",\"dateModified\":\"2025-11-11T12:43:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\"},\"wordCount\":4557,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp\",\"keywords\":[\"guides\",\"save-time\"],\"articleSection\":[\"Outbound Sales\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\",\"url\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\",\"name\":\"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage & Enrich Your Pipeline - PhantomBuster Blog\",\"isPartOf\":{\"@id\":\"https:\/\/blogv2.phantombuster.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp\",\"datePublished\":\"2023-05-15T00:00:00+00:00\",\"dateModified\":\"2025-11-11T12:43:27+00:00\",\"author\":{\"@id\":\"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16\"},\"description\":\"Learn the best keyboard shortcuts, Google Sheets functions, and toolbars to transform data inside your Sheet.\",\"breadcrumb\":{\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage\",\"url\":\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp\",\"contentUrl\":\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp\",\"width\":1200,\"height\":800},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/blogv2.phantombuster.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Outbound Sales\",\"item\":\"https:\/\/blogv2.phantombuster.com\/blog\/category\/outbound-sales\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &#038; Enrich Your Pipeline\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blogv2.phantombuster.com\/blog\/#website\",\"url\":\"https:\/\/blogv2.phantombuster.com\/blog\/\",\"name\":\"PhantomBuster Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blogv2.phantombuster.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16\",\"name\":\"Phantom Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2025\/03\/cropped-Phantombuster_logo_-_square-1-1-96x96.jpg\",\"contentUrl\":\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2025\/03\/cropped-Phantombuster_logo_-_square-1-1-96x96.jpg\",\"caption\":\"Phantom Team\"},\"description\":\"PhantomBuster\u2019s mission is to enable thousands of companies to boost their growth by finding and connecting with their ideal customers on major social media platforms.\",\"url\":\"https:\/\/phantombuster.com\/blog\/author\/the-phantombuster-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage & Enrich Your Pipeline - PhantomBuster Blog","description":"Learn the best keyboard shortcuts, Google Sheets functions, and toolbars to transform data inside your Sheet.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/","og_locale":"en_US","og_type":"article","og_title":"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage & Enrich Your Pipeline - PhantomBuster Blog","og_description":"Learn the best keyboard shortcuts, Google Sheets functions, and toolbars to transform data inside your Sheet.","og_url":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/","og_site_name":"PhantomBuster Blog","article_published_time":"2023-05-15T00:00:00+00:00","article_modified_time":"2025-11-11T12:43:27+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp","type":"image\/webp"}],"author":"Phantom Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Phantom Team","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#article","isPartOf":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/"},"author":{"name":"Phantom Team","@id":"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16"},"headline":"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &#038; Enrich Your Pipeline","datePublished":"2023-05-15T00:00:00+00:00","dateModified":"2025-11-11T12:43:27+00:00","mainEntityOfPage":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/"},"wordCount":4557,"commentCount":0,"image":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp","keywords":["guides","save-time"],"articleSection":["Outbound Sales"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/","url":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/","name":"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage & Enrich Your Pipeline - PhantomBuster Blog","isPartOf":{"@id":"https:\/\/blogv2.phantombuster.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage"},"image":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp","datePublished":"2023-05-15T00:00:00+00:00","dateModified":"2025-11-11T12:43:27+00:00","author":{"@id":"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16"},"description":"Learn the best keyboard shortcuts, Google Sheets functions, and toolbars to transform data inside your Sheet.","breadcrumb":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#primaryimage","url":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp","contentUrl":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2023\/05\/The-Ultimate-Google-Sheets-Formulas-Cheat-Sheet.webp","width":1200,"height":800},{"@type":"BreadcrumbList","@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/blogv2.phantombuster.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Outbound Sales","item":"https:\/\/blogv2.phantombuster.com\/blog\/category\/outbound-sales\/"},{"@type":"ListItem","position":3,"name":"Google Sheets Formulas Cheat Sheet for Sales Professionals: Track, Manage &#038; Enrich Your Pipeline"}]},{"@type":"WebSite","@id":"https:\/\/blogv2.phantombuster.com\/blog\/#website","url":"https:\/\/blogv2.phantombuster.com\/blog\/","name":"PhantomBuster Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogv2.phantombuster.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16","name":"Phantom Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogv2.phantombuster.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2025\/03\/cropped-Phantombuster_logo_-_square-1-1-96x96.jpg","contentUrl":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2025\/03\/cropped-Phantombuster_logo_-_square-1-1-96x96.jpg","caption":"Phantom Team"},"description":"PhantomBuster\u2019s mission is to enable thousands of companies to boost their growth by finding and connecting with their ideal customers on major social media platforms.","url":"https:\/\/phantombuster.com\/blog\/author\/the-phantombuster-team\/"}]}},"_links":{"self":[{"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/posts\/4355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/comments?post=4355"}],"version-history":[{"count":13,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/posts\/4355\/revisions"}],"predecessor-version":[{"id":8310,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/posts\/4355\/revisions\/8310"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/media\/4900"}],"wp:attachment":[{"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/media?parent=4355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/categories?post=4355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/tags?post=4355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}