- Видео 11
- Просмотров 11 996
Ritechannel
Добавлен 1 окт 2021
We show sales Leaders how to get their "Data Ducks" in a row with the Ritechannel strategy so they can begin untangling, automating and optimizing their DataOps process.
How to quickly find an email format so you can apply it to other employees at the same company!!
Do you have emails for some employees at a company but not others? This is an easy method to find thousands of emails using the data you already have.
docs.google.com/spreadsheets/d/1tM2Rb9MmZAKDlJDnx1F8AybrXhByCmBzn7e8XO_SiYE/edit#gid=0
docs.google.com/spreadsheets/d/1tM2Rb9MmZAKDlJDnx1F8AybrXhByCmBzn7e8XO_SiYE/edit#gid=0
Просмотров: 49
Видео
How and Why you should be using Linkedin IDs in Salesforce
Просмотров 282 года назад
Are you managing duplicates through name matching? maybe you've stepped up to fuzzy name matching? Why not solve the problem at the root by adding LinkedinID's to your data? In this video I'll show you why linkedin ID's are useful in your crm, and then how to use them in Salesforce. #data #linkedin #salesforce
How to use LinkedIn Search Booleans
Просмотров 42 года назад
99% of LinkedIn Sales Nav's power comes from the advanced search functionality to get far more detailed results. Follow along to learn how we use Booleans at Ritechannel to get really accurate search results! #linkedin #salesNavigator #booleanSearch
The Easiest Way to Import Contact and Accounts into Your CRM!!!
Просмотров 142 года назад
Are you wondering if there's an easier way to import contacts into your CRM? how about the easiest way to do it. Use this formula to quickly create an import sheet for your CRM #data, #dataops, #googleSheets, #excel, #salesforce, #salesenablement, #growthHacking, #formulas, #howto, #CRM, #leads, #contacts, #accounts, #growth, #leadgen, #Salesdata, #salesintellegence, #salesloft, #hubspot, #outr...
How to Make Your Reps 8x More Productive
Просмотров 42 года назад
What’s the lowest productivity activity an SDR does every day? Calling people and not getting through. Call connect rates are less than 7%. That means 93% of the time your reps are dialling, they’re effectively wasting time. Why? Nothing has been left behind. There’s not an email to refer to, there’s not a profile to check out on Linkedin in, the call vanishes into the ether. But calls are stil...
How to Quickly Format Phone Numbers in Google Sheets
Просмотров 3,8 тыс.2 года назад
A lot of the time when scraping data or dealing with data your reps have put into the system you'll come up against very "human" phone formats. This formula will turn all of those messy phone numbers into a consistent format. =" 1"®EXREPLACE(REGEXREPLACE(to_text(A2),"[^0-9] ",""),"^1","") If you have any questions or issues with the formula, let me know in a message or comment and I'll respo...
How to create objects and link them in salesforce with lookup fields
Просмотров 1382 года назад
It can be tricky to understand how salesforce stores and links data. In this video I'll give an overview of: - What are lookup fields in salesforce? - How to use lookup fields - What are Master Detail Records - How to link objects - Which settings you should use when creating objects and lookup fields - How to make your new custom objects visible on the salesforce navigation bar Let me know via...
How to remove letter accents in google sheets using a simple formula!
Просмотров 3,4 тыс.2 года назад
Sometimes when working with fuzzy data you'll come across errors caused by letter accents. Certain CRMS won't accept them, others will change the letters to something completely different, and when you go to use your data tools to find information for these contacts you'll find many of them won't properly format letter accents. So what formula should you use to quickly remove letter accents fro...
Learn how to add formulas to google forms responses in 5 minutes
Просмотров 4,6 тыс.2 года назад
With google forms it can be really tricky to apply formulas because google forms appends a new row to the response sheet, rather than inputting data on an existing row. This means any formulas you add to the empty rows of your response sheet will not apply to your form responses. Watch this video for an easy solution! #data, #dataops, #googleSheets, #excel, #salesforce, #salesenablement, #growt...
How to convert a list of company URLS into email domains in 5 Minutes
Просмотров 172 года назад
"=regexreplace(COMPANYURL,"|| |www.|/.*$" , "" )" There's a bunch of tools out there that help you find data on prospects. Many of them require a clean domain to search with. Use this formula to format any company URL into a usable domain in seconds! #data, #dataops, #googleSheets, #excel, #salesforce, #salesenablement, #growthHacking, #formulas, #howto, #CRM, #leads, #contacts, #accounts, #gro...
How to get started in Salesforce and Create your first custom Field
Просмотров 62 года назад
How to get started customizing salesforce in less than 15 minutes! So you've got your new salesforce org and you have no idea how it works or what to do. What should you do first? Follow along with this video and I'll give an overview of the following: - What is an object in salesforce? - What is a field in salesforce? - What is a record in salesforce? - What does "ORG" mean in salesforce? - Ho...
Thank you for this, it helped
What do I do when I want to extract a day, month and year in the formula? Somehow it doesn't work..
Thank you very much ❤❤
Really helpful thanks, any chance you can add Ø to the list please?
Good
Thank you, super useful !!!
Hello, if I want it formatted like this "### ### ####", Where can I change in your formula?
Absolute legend. Thanks for allowing access to this formula
thank you!!!
How could I apply to this? Is the array to complicated of an argument? COUNTIF(J2:AB2, "Yes")/ (COUNTIF(J2:AB2, "Yes") + COUNTIF(J2:AB2, "No"))
I can't get this to work with arrayformula to span the column. Any tips for this?
Google sheets gives me an error each time I try to paste the formula. Is this still working for everyone else?
petit tip pour les français : remplacez la virgule par un point virgule sinon le formule plante
Another interesting way on doing that: REGEXREPLACE(YOUR_CELL "[áäàâãå]", "a") As you can imagine, all letters in the [] will be changed to "a" So you can so a similar way as is shown on the video on repeating the same function inside the function ;) Cheers!
I'm amazed that you can change the sheet name, column header text and the order of columns, and the form still works correctly!
I cant set my +255 code😢
I copy the formula and get mistake, any updates?
It's always the channels with just a few subscribers which provide the most help on RUclips. :P Thanks. It was very helpful and time-saving.
I'm getting an error message, opening bracket missing but I can't find it...
Tks, your video is a time saver.
Simple
Hiper useful video, thank you !
Okay so I just had the NEED for something like this query and tbh, I am glad i got to watch this video. wih a simple copy paste, I just reformatted like 13k phone numbers. Brother thank you so much for uploading this video. Cheers!
Thank you so much man!!!
man, you are hero!
Hello, thanks for the video. Can you tell me where I can find the formula? Thanks
letter ü was missing, nevertheless you saved be a ton of time! thx :-)