{"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":"2026-07-17T07:59:25","modified_gmt":"2026-07-17T07:59:25","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<p>&nbsp;<\/p>\n<style>.elementor-12459 .elementor-element.elementor-element-0156978{--display:flex;--min-height:240px;--flex-direction:row;--container-widget-width:calc( ( 1 - var( --container-widget-flex-grow ) ) * 100% );--container-widget-height:100%;--container-widget-flex-grow:1;--container-widget-align-self:stretch;--flex-wrap-mobile:wrap;--align-items:center;--gap:30px 30px;--row-gap:30px;--column-gap:30px;border-style:solid;--border-style:solid;border-width:1px 1px 1px 1px;--border-top-width:1px;--border-right-width:1px;--border-bottom-width:1px;--border-left-width:1px;border-color:#0000001A;--border-color:#0000001A;--border-radius:12px 12px 12px 12px;--padding-top:24px;--padding-bottom:24px;--padding-left:24px;--padding-right:24px;}.elementor-12459 .elementor-element.elementor-element-0156978:not(.elementor-motion-effects-element-type-background), .elementor-12459 .elementor-element.elementor-element-0156978 > .elementor-motion-effects-container > .elementor-motion-effects-layer{background-image:url(\"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2026\/07\/pb-colors.webp\");background-position:bottom center;background-repeat:no-repeat;background-size:cover;}.elementor-12459 .elementor-element.elementor-element-b5d92f3{--display:flex;--flex-direction:column;--container-widget-width:100%;--container-widget-height:initial;--container-widget-flex-grow:0;--container-widget-align-self:initial;--flex-wrap-mobile:wrap;--justify-content:center;--gap:12px 12px;--row-gap:12px;--column-gap:12px;--margin-top:0px;--margin-bottom:0px;--margin-left:0px;--margin-right:0px;--padding-top:0px;--padding-bottom:0px;--padding-left:0px;--padding-right:0px;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c .elementor-icon-wrapper{text-align:start;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c .elementor-icon{font-size:27px;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c .elementor-icon svg{height:27px;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c .elementor-icon-wrapper svg{width:auto;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c > .elementor-widget-container{margin:0px 0px 12px 0px;padding:0px 0px 0px 0px;}.elementor-12459 .elementor-element.elementor-element-6b50ef1{text-align:start;}.elementor-12459 .elementor-element.elementor-element-6b50ef1 .elementor-heading-title{font-family:\"Roboto\", Sans-serif;font-size:36px;font-weight:500;text-transform:none;line-height:1.22em;color:var( --e-global-color-text );}.elementor-12459 .elementor-element.elementor-element-6b50ef1 > .elementor-widget-container{margin:0px 0px 0px 0px;padding:0px 0px 0px 0px;}.elementor-12459 .elementor-element.elementor-element-2944270 .elementor-button{transition-duration:0.7s;}.elementor-12459 .elementor-element.elementor-element-2944270 > .elementor-widget-container{margin:0px 0px 0px 0px;padding:0px 0px 0px 0px;}.elementor-12459 .elementor-element.elementor-element-2944270{width:auto;max-width:auto;}.elementor-12459 .elementor-element.elementor-element-3b529cf{--display:flex;--flex-direction:column;--container-widget-width:100%;--container-widget-height:initial;--container-widget-flex-grow:0;--container-widget-align-self:initial;--flex-wrap-mobile:wrap;--justify-content:center;--margin-top:0px;--margin-bottom:0px;--margin-left:0px;--margin-right:0px;--padding-top:0px;--padding-bottom:0px;--padding-left:0px;--padding-right:0px;}.elementor-12459 .elementor-element.elementor-element-3b529cf:not(.elementor-motion-effects-element-type-background), .elementor-12459 .elementor-element.elementor-element-3b529cf > .elementor-motion-effects-container > .elementor-motion-effects-layer{background-position:center center;background-repeat:no-repeat;background-size:cover;}.elementor-12459 .elementor-element.elementor-element-7459f0b{--spacer-size:190px;}@media(max-width:1024px){.elementor-12459 .elementor-element.elementor-element-0156978{--margin-top:0px;--margin-bottom:0px;--margin-left:0px;--margin-right:0px;}.elementor-12459 .elementor-element.elementor-element-6b50ef1 .elementor-heading-title{font-size:32px;}}@media(min-width:768px){.elementor-12459 .elementor-element.elementor-element-0156978{--width:min( 100%, 712px );}.elementor-12459 .elementor-element.elementor-element-b5d92f3{--width:55%;}.elementor-12459 .elementor-element.elementor-element-3b529cf{--width:45%;}}@media(max-width:767px){.elementor-12459 .elementor-element.elementor-element-0156978{--width:min( 100%, 650px );--min-height:120px;--flex-direction:row;--container-widget-width:calc( ( 1 - var( --container-widget-flex-grow ) ) * 100% );--container-widget-height:100%;--container-widget-flex-grow:1;--container-widget-align-self:stretch;--flex-wrap-mobile:wrap;--align-items:center;--gap:24px 24px;--row-gap:24px;--column-gap:24px;--flex-wrap:nowrap;--margin-top:0px;--margin-bottom:0px;--margin-left:0px;--margin-right:0px;--padding-top:18px;--padding-bottom:18px;--padding-left:18px;--padding-right:18px;}.elementor-12459 .elementor-element.elementor-element-b5d92f3{--width:50%;--gap:9px 9px;--row-gap:9px;--column-gap:9px;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c .elementor-icon{font-size:4vw;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c .elementor-icon svg{height:4vw;}.elementor-12459 .elementor-element.elementor-element-1eaaf5c > .elementor-widget-container{margin:0px 0px 9px 0px;}.elementor-12459 .elementor-element.elementor-element-6b50ef1 .elementor-heading-title{font-size:18px;}.elementor-12459 .elementor-element.elementor-element-3b529cf{--width:50%;--margin-top:0px;--margin-bottom:0px;--margin-left:0px;--margin-right:0px;}.elementor-12459 .elementor-element.elementor-element-7459f0b{--spacer-size:30vw;}}<\/style>\t\t<div data-elementor-type=\"single-post\" data-elementor-id=\"12459\" class=\"elementor elementor-12459\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-0156978 e-con-full e-flex e-con e-parent\" data-id=\"0156978\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-b5d92f3 e-con-full e-flex e-con e-child\" data-id=\"b5d92f3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1eaaf5c elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"1eaaf5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<div class=\"elementor-icon\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"214\" height=\"27\" viewBox=\"0 0 214 27\" fill=\"none\"><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M24.2907 13.4344H22.6711V10.3112C22.6711 5.13641 18.4761 0.941406 13.3013 0.941406C8.1265 0.941406 3.93143 5.13641 3.93143 10.3112V13.4344H2.34168C0.951068 13.4344 0.404998 15.238 1.56205 16.0093L3.93143 17.5917V21.2427C3.93143 22.492 4.93253 23.0339 6.11772 23.429C7.05471 23.7413 7.6794 25.303 8.9287 25.303C9.5533 25.303 9.9132 24.9906 10.6305 24.9906C11.5675 24.9906 12.052 25.9276 13.3013 25.9276C14.5506 25.9276 15.02 24.9906 15.9581 24.9906C16.6549 24.9906 17.0492 25.303 17.6739 25.303C18.9232 25.303 19.5758 23.6562 20.4848 23.429C21.7342 23.1167 22.6711 22.492 22.6711 21.2427V17.6144L25.0703 16.0093C26.2274 15.238 25.6813 13.4344 24.2907 13.4344Z\" fill=\"white\"><\/path><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M13.3055 26.8601C12.3771 26.8601 11.7474 26.4834 11.2876 26.2084C10.9831 26.0262 10.8026 25.9232 10.6347 25.9232C10.4027 25.9232 10.2314 25.9751 9.9944 26.0471C8.4698 26.5907 7.4094 25.8857 6.52408 24.9129C6.27768 24.6589 5.9984 24.371 5.82562 24.3135C4.42589 23.8938 2.95801 22.9467 2.99868 21.2382L2.99864 18.0882L1.04588 16.7841C0.596689 16.4846 0.273869 16.0631 0.112889 15.5655C-0.192001 14.6622 0.138129 13.5718 0.892899 12.9894C1.53951 12.4688 2.20365 12.4774 2.99864 12.493C2.97178 10.4042 2.9205 8.22932 3.80907 6.29465C5.35388 2.54259 9.2406 0 13.3055 0C17.355 0 21.2573 2.54259 22.8019 6.29465C23.6901 8.22872 23.6396 10.4077 23.6123 12.493C24.4164 12.479 25.0933 12.461 25.7479 12.9894C26.5026 13.5719 26.8328 14.6622 26.5279 15.5655C26.367 16.0631 26.0441 16.4846 25.5943 16.7845L23.6123 18.1104V21.2382C23.6026 22.9481 22.3754 23.9353 20.7163 24.3335C20.586 24.3695 20.2665 24.7022 20.0755 24.901C19.1769 25.8957 18.1399 26.5868 16.6026 26.0471C16.3689 25.9778 16.1843 25.9232 15.9623 25.9232C15.7958 25.9232 15.618 26.0256 15.3181 26.2067C14.8613 26.4824 14.2357 26.8601 13.3055 26.8601ZM24.2985 13.4344H22.6789V10.3112C22.6789 5.1364 18.4839 0.9414 13.3091 0.9414C8.1343 0.9414 3.93924 5.1364 3.93924 10.3112V13.4344H2.34949C0.958879 13.4344 0.412809 15.238 1.56986 16.0093L3.93924 17.5917V21.2427C3.93924 22.492 4.94035 23.0339 6.12554 23.429C7.06252 23.7413 7.6872 25.303 8.9365 25.303C9.5611 25.303 9.921 24.9906 10.6384 24.9906C11.5753 24.9906 12.0598 25.9276 13.3091 25.9276C14.5584 25.9276 15.0278 24.9906 15.966 24.9906C16.6627 24.9906 17.057 25.303 17.6817 25.303C18.931 25.303 19.5836 23.6562 20.4927 23.429C21.742 23.1167 22.6789 22.492 22.6789 21.2427V17.6144L25.0782 16.0093C26.2352 15.238 25.6891 13.4344 24.2985 13.4344ZM12.5412 9.52602C12.5412 10.8197 11.8421 11.8685 10.9796 11.8685C10.1171 11.8685 9.418 10.8197 9.418 9.52602C9.418 8.23232 10.1171 7.18362 10.9796 7.18362C11.8421 7.18362 12.5412 8.23232 12.5412 9.52602ZM17.2248 9.52602C17.2248 10.8197 16.5257 11.8685 15.6632 11.8685C14.8007 11.8685 14.1016 10.8197 14.1016 9.52602C14.1016 8.23232 14.8007 7.18362 15.6632 7.18362C16.5257 7.18362 17.2248 8.23232 17.2248 9.52602Z\" fill=\"#1E1E1F\"><\/path><path d=\"M160.934 16.5566C160.934 18.2635 162.098 19.0303 163.286 19.0303C164.473 19.0301 165.635 18.2634 165.635 16.5566V9.20702H168.902V21.9756H165.635V20.5898C165.091 21.4557 164.101 22.2226 162.542 22.2226C160.167 22.2224 157.667 20.515 157.667 16.6797V9.20702H160.934V16.5566ZM75.0361 8.85942C78.6988 8.85942 80.7275 11.1855 80.7275 14.7236V21.9746H77.4619V20.5136C76.8678 21.479 75.8532 22.2216 73.8984 22.2217C70.9783 22.2217 69.2462 20.7867 69.2461 18.4355C69.2461 16.5797 69.8899 15.4661 71.6709 14.625C72.933 14.0309 75.482 13.8332 77.4121 13.6845V13.6592C77.1891 12.5212 76.3726 11.8037 75.0361 11.8037C73.8983 11.8037 73.1057 12.3485 72.7842 13.2148H69.4941C70.0137 10.5423 71.9186 8.85942 75.0361 8.85942ZM112.108 8.85942C115.771 8.85942 117.799 11.1855 117.799 14.7236V16.3574C117.799 19.896 115.77 22.2217 112.108 22.2217C108.446 22.2215 106.418 19.8959 106.417 16.3574V14.7236C106.417 11.1856 108.446 8.85952 112.108 8.85942ZM198.081 8.85942C201.743 8.85942 203.773 11.1855 203.773 14.7236V16.7031H195.656V16.7773C195.656 18.2867 196.522 19.2772 198.081 19.2773C199.219 19.2773 200.012 18.7322 200.333 17.8662H203.65C203.13 20.5387 201.199 22.2217 198.081 22.2217C194.419 22.2215 192.391 19.8959 192.391 16.3574V14.7236C192.391 11.1856 194.419 8.85952 198.081 8.85942ZM176.152 8.85542C178.75 8.85542 180.877 10.0926 181.1 12.9873H177.76C177.587 12.171 176.868 11.7998 176.053 11.7998C175.113 11.7998 174.567 12.1716 174.542 12.7656C174.544 13.3094 174.988 13.5812 175.533 13.7051L178.404 14.3486C179.79 14.6702 181.497 15.6355 181.497 18.2832C181.497 21.1292 179.195 22.2177 176.523 22.2177C173.875 22.2176 171.104 20.8565 170.98 17.8379H174.247C174.395 18.8275 175.559 19.2734 176.622 19.2734C177.266 19.2734 178.23 19.1243 178.23 18.2832C178.23 17.7636 177.86 17.4662 177.092 17.2929L174.419 16.6992C173.035 16.3776 171.277 15.2891 171.277 12.79C171.277 10.2911 173.529 8.85552 176.152 8.85542ZM101.569 9.20802H104.712V12.1523H101.569V18.0166C101.569 18.6103 101.717 19.0311 102.508 19.0312H104.712V21.9756H101.569C99.2925 21.9756 98.3025 20.7632 98.3025 18.709V12.1523H96.4961V9.20802H98.3025V6.3125H101.569V9.20802ZM187.535 9.20802H190.676V12.1523H187.535V18.0166C187.535 18.6103 187.682 19.0311 188.473 19.0312H190.676V21.9756H187.535C185.258 21.9756 184.268 20.7632 184.268 18.709V12.1523H182.46V9.20802H184.268V6.3125H187.535V9.20802ZM213.544 12.1758H212.01C210.773 12.1759 209.587 12.9187 209.585 14.6504V21.9756H206.32V9.20702H209.585V10.5927C209.957 9.75162 211.046 8.98442 212.555 8.98442H213.544V12.1758ZM47.7178 4.65234C51.8248 4.65239 53.7061 7.47342 53.7061 10.6406C53.706 13.783 51.8248 16.6532 47.7178 16.6533H43.9561V21.9736H40.6406V4.65234H47.7178ZM58.8047 10.3183C59.3739 9.45242 60.6604 8.85852 61.7988 8.85842C64.3968 8.85842 66.9208 10.6404 66.9209 14.4013V21.9736H63.6543V14.5254C63.6543 12.793 62.4667 12.0508 61.2295 12.0508C59.9924 12.0509 58.8047 12.7932 58.8047 14.5254V21.9736H55.5391V4.65234H58.8047V10.3183ZM149.671 4.65234C153.185 4.65235 155.141 6.6319 155.141 9.62602C155.141 11.0611 154.622 12.3234 153.583 13.1152C154.795 14.0305 155.561 15.3664 155.561 16.9004C155.561 19.9685 153.632 21.9734 150.068 21.9736H142.497V4.65234H149.671ZM89.7871 8.85542C92.3851 8.85542 94.9092 10.6374 94.9092 14.3984V21.9707H91.6426V14.5224C91.6426 12.7901 90.455 12.0478 89.2178 12.0478C87.9807 12.048 86.793 12.7903 86.793 14.5224V21.9707H83.5273V9.20212H86.793V10.3154C87.3622 9.44952 88.6486 8.85552 89.7871 8.85542ZM133.958 8.85542C137.2 8.85542 139.577 10.6622 139.577 14.3984V21.9707H136.309V14.5224C136.309 12.8149 135.122 12.0478 133.958 12.0478C132.796 12.0479 131.609 12.815 131.609 14.5224V21.9707H128.342V14.5224C128.342 12.8151 127.154 12.048 125.992 12.0478C124.828 12.0478 123.641 12.8149 123.641 14.5224V21.9707H120.376V9.20212H123.641V10.2656C124.258 9.39972 125.423 8.85552 126.536 8.85542C127.872 8.85542 129.084 9.35022 129.975 10.5381C130.891 9.42472 132.202 8.85552 133.958 8.85542ZM77.4609 16.3789C75.6048 16.5024 73.8224 16.6507 73.2041 16.9726C72.6599 17.2448 72.5117 17.5175 72.5117 18.0615C72.5119 18.68 72.9818 19.3485 74.4414 19.3486C76.1236 19.3486 77.4608 18.4077 77.4609 16.7998V16.3789ZM112.108 11.8008C110.549 11.8008 109.684 12.7903 109.684 14.2998V16.7744C109.684 18.2837 110.549 19.2734 112.108 19.2734C113.667 19.2734 114.535 18.2837 114.535 16.7744V14.2998C114.535 12.7903 113.667 11.8008 112.108 11.8008ZM145.812 18.6816H150.167C151.529 18.6816 152.247 17.9887 152.247 16.7763C152.247 15.5391 151.43 14.8711 150.167 14.8711H145.812V18.6816ZM198.081 11.8008C196.621 11.8008 195.78 12.6671 195.656 13.9785V14.0029H200.482V13.9785C200.383 12.6423 199.542 11.8008 198.081 11.8008ZM43.957 13.3603H47.7187C49.5492 13.3602 50.3906 11.9748 50.3906 10.6386C50.3906 9.30252 49.5492 7.94152 47.7187 7.94142H43.957V13.3603ZM145.812 11.5791H149.747C151.008 11.5791 151.826 10.9355 151.826 9.74802C151.826 8.53562 151.008 7.94142 149.747 7.94142H145.812V11.5791Z\" fill=\"#1E1E1F\"><\/path><\/svg>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6b50ef1 elementor-widget elementor-widget-heading\" data-id=\"6b50ef1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\">Automate your Google Sheets workflow<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2944270 elementor-widget__width-auto elementor-widget elementor-widget-button\" data-id=\"2944270\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/phantombuster.com\/signup?utm_content=sheets-cheat-sheet-signup\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Start free trial<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3b529cf e-con-full e-flex e-con e-child\" data-id=\"3b529cf\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7459f0b elementor-widget elementor-widget-spacer\" data-id=\"7459f0b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\n<p>&nbsp;<\/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><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><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<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><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><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><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><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><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><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><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><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><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><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><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>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>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<div class=\"wp-layout-normal-table\"><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><\/div>\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<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<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<div class=\"wp-layout-normal-table\"><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><\/div>\n<h3>Editing shortcuts for quick data updates<\/h3>\n<div class=\"wp-layout-normal-table\"><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><\/div>\n<h3>Formatting shortcuts for consistent sales reporting<\/h3>\n<div class=\"wp-layout-normal-table\"><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><\/div>\n<h3>Formula shortcuts to speed up analysis<\/h3>\n<div class=\"wp-layout-normal-table\"><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><\/div>\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<div class=\"wp-layout-normal-table\"><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><\/div>\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 v28.1 - 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=\"2026-07-17T07:59:25+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=\"21 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:\\\/\\\/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\":\"2026-07-17T07:59:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/phantombuster.com\\\/blog\\\/outbound-sales\\\/google-sheets-formulas-cheat-sheet\\\/\"},\"wordCount\":4562,\"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:\\\/\\\/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\":\"2026-07-17T07:59:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/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:\\\/\\\/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:\\\/\\\/phantombuster.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/phantombuster.com\\\/blog\\\/\",\"name\":\"PhantomBuster Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/phantombuster.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/phantombuster.com\\\/blog\\\/#\\\/schema\\\/person\\\/7233a7fadfa58fe280c099c935ee0e16\",\"name\":\"Phantom Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/phantombuster.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-Phantombuster_logo_-_square-1-1-96x96.jpg\",\"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":"2026-07-17T07:59:25+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":"21 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:\/\/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":"2026-07-17T07:59:25+00:00","mainEntityOfPage":{"@id":"https:\/\/phantombuster.com\/blog\/outbound-sales\/google-sheets-formulas-cheat-sheet\/"},"wordCount":4562,"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:\/\/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":"2026-07-17T07:59:25+00:00","author":{"@id":"https:\/\/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:\/\/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:\/\/phantombuster.com\/blog\/#website","url":"https:\/\/phantombuster.com\/blog\/","name":"PhantomBuster Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/phantombuster.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/phantombuster.com\/blog\/#\/schema\/person\/7233a7fadfa58fe280c099c935ee0e16","name":"Phantom Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/phantombuster.com\/blog\/wp-content\/uploads\/2025\/03\/cropped-Phantombuster_logo_-_square-1-1-96x96.jpg","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":16,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/posts\/4355\/revisions"}],"predecessor-version":[{"id":13195,"href":"https:\/\/phantombuster.com\/blog\/wp-json\/wp\/v2\/posts\/4355\/revisions\/13195"}],"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}]}}