How to Build a CRM in Google Sheet in Hindi - A Comprehensive Guide

  Рет қаралды 29,320

Business Technology by Jatin Gola

Business Technology by Jatin Gola

Күн бұрын

Thanks for Watching
If you need any help or system So please fill this form : script.google....
----------------------------------------------------------------------------------------------------------------------------------------
How to Build a CRM in Google Sheet in Hindi - A Comprehensive Guide
----------------------------------------------------------------------------------------------------------------------------------------
More Videos :
=Vlookup+Match 👇👇
• =Vlookup+Match
=Sequence(Row,Column,Start,gap) 👇👇
• =Sequence(Row,Column,S...
=Match(Search key, Range,0) 👇👇
• =Match(Search key, Ran...
=Index(Range,Row no,Column no) 👇👇
• =Index(Range,Row no,Co...
=Forecast( Future Prediction😎) 👇👇
• =Forecast( Future Pred...
=ABS(Range) 👇👇
• =ABS(Range)
={Range 1, Range 2} and ={Range 1; Range 2} 👇👇
• How to combine the dat...
=Unique(range) 👇👇
• =Unique(range)
=Googletranslate 👇👇
• =Googletranslate
=weekday(date), =Weeknum(date) 👇👇
• =weekday(date), =Weekn...
=Filter( Range , range = criteria , range2 = criteria2) 👇👇
• =Filter( Range , range...
=Countif(range,criteria) 👇👇
• =Countif(range,criteria)
=LEN(count length of the value) 👇👇
• =LEN(count length of t...
=SPLIT(text to column) 👇👇
• =SPLIT(text to column)
=COUNT(Range!) and =COUNTA(Range!) 👇👇
• =COUNT(Range!) and =CO...
=SUMIFS(sum_range, criteria_range1, criterion1, criteria_range2, criterion2) 👇👇
• =SUMIFS(sum_range, cri...
=SUMIF(range, criterion, [sum_range]) 👇👇
• =SUMIF(range, criterio...
=sum(range), =count(range) 👇👇
• =sum(range), =count(ra...
=IMPORTRANGE("URL/ID","Sheet Name!A:J") 👇👇
• =IMPORTRANGE("URL/ID",...
----------------------------------------------------------------------------------------------------------------------------------------
Tags
customer relationship management
crm
free crm
customer relationship management system
google sheets
google sheets tutorial for beginners
google sheets tutorial
sales
sales techniques
sales training
sales and marketing
sales lead
sales lead generation techniques
sales leads
sales lead generation
sales lead excel template
car sales lead generation
b2b sales lead generation
how can you improve sales lead generation
linkedin sales lead generation
#googlesheets #crm #sales #leadgeneration #followups #learngooglesheet

Пікірлер: 43
@music.shiksha
@music.shiksha Жыл бұрын
It was very helpful in creating my own CRM. Thank you so much for this video!
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
You're very welcome!
@amriksingh-tr8ys
@amriksingh-tr8ys 5 ай бұрын
Ager data jayda ho ye sare formule failed ho jaynge Appscirpt se sahi rehta hai
@businesstechnologybyjatingola
@businesstechnologybyjatingola 5 ай бұрын
Yes but formula value and ke baad paste special krdo
@GrowwithAditya
@GrowwithAditya Жыл бұрын
Sir I have used all the formula working fine but just facing one problem once we have added date for first time in schedule date coloumn and again when we try to change date , the date is not changing in master sheet , In spoc status as we are updating date through google form it is adding timestamp and showing us the changes , but in master sheet the schedule date is not changing , sir please check and let me know what i can do to solve it It is a bit urgent
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
before vlookup you need to sort data using sort formula the use vlookup like video =vlookup(clientid,sort(formrespose!A:F,1,0),column,0)
@sanketchavan9843
@sanketchavan9843 8 ай бұрын
Tumhare video blur hai aur formals bena batye add kardiya apne
@businesstechnologybyjatingola
@businesstechnologybyjatingola 8 ай бұрын
ok we will resolve this issue
@shivammahajan1991
@shivammahajan1991 Жыл бұрын
Without array formula or copydown, formula will not itself copy down to new cell... I tried with array formula and it worked properly...
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
great
@SarthakSabharwalMusic
@SarthakSabharwalMusic Жыл бұрын
Can you please upload this template and give us a link?
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
Please fill the form.
@manzoorahmadthakur9648
@manzoorahmadthakur9648 Жыл бұрын
No learning experience from this video, content is good but confined to yourself
@emranshah-j8d
@emranshah-j8d 10 ай бұрын
How much u charge for creating one customised CRM for my business?
@businesstechnologybyjatingola
@businesstechnologybyjatingola 10 ай бұрын
kzbin.info/www/bejne/aGOrdX5qqdCqqbc
@businesstechnologybyjatingola
@businesstechnologybyjatingola 10 ай бұрын
It's helpful for you
@BusinessBananaShikhe
@BusinessBananaShikhe Жыл бұрын
Sheet link do
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
please create it yourself
@suvijkidsphotography7849
@suvijkidsphotography7849 Жыл бұрын
Thak you so much......
@RoseRose-ev2ij
@RoseRose-ev2ij 8 ай бұрын
Did not find value 1 in vlookup evaluation
@businesstechnologybyjatingola
@businesstechnologybyjatingola 8 ай бұрын
please fill form we will call you
@megabite3178
@megabite3178 Жыл бұрын
Yar cha gaye ho ! Love for Pakistan
@krish0094
@krish0094 4 ай бұрын
After ready to these CRM how can I connect with HOUSING, 99 ACERS , etc for automatic leads capturing ??
@businesstechnologybyjatingola
@businesstechnologybyjatingola 4 ай бұрын
Using API of 99 Acers
@MindfulJourneyWithSarika
@MindfulJourneyWithSarika 7 ай бұрын
If we want to see all the follow up remarks of a specific lead. Instead of overiding how can we create a new row for next follow up remark for the same lead
@businesstechnologybyjatingola
@businesstechnologybyjatingola 7 ай бұрын
There is a history column there you can see the history of remarks
@AussieRemovalist
@AussieRemovalist Жыл бұрын
can you send link of this sheet? i can make changes accordingly.
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
Please create it your self with me on this video
@civilviews5336
@civilviews5336 9 ай бұрын
i want to learn plz help us
@businesstechnologybyjatingola
@businesstechnologybyjatingola 8 ай бұрын
please see more videos of tutorials
@ajinkyatapkire4022
@ajinkyatapkire4022 Жыл бұрын
Very nicely explained
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
Thank you so much 🙂
@NehaMishra-p1f
@NehaMishra-p1f Жыл бұрын
Sir i want last 5 remaks for history. how can i add.
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
Good approach will created and update
@MISVRCLogistics
@MISVRCLogistics 3 ай бұрын
@@businesstechnologybyjatingola Sir,have you updated this?Pls share link.
@AMV-EDITZ-ANIME
@AMV-EDITZ-ANIME Жыл бұрын
Sir ye crm banaya hai but isme lead capture form me kuchh error a Raha hai apki thodi help chahiye
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
Call me
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
please collect the contact no in description of the video
@kcsprideproductsllp6693
@kcsprideproductsllp6693 Жыл бұрын
Hi sir simple and smart crm
@businesstechnologybyjatingola
@businesstechnologybyjatingola Жыл бұрын
Thank you very much
@RoseRose-ev2ij
@RoseRose-ev2ij 8 ай бұрын
Vlookup error
@businesstechnologybyjatingola
@businesstechnologybyjatingola 8 ай бұрын
give me the formula
Simple Lead CRM Tutorial - Google Sheets
15:24
Sheets Ninja
Рет қаралды 27 М.
Grow Your Sales Exponentially using Google Sheet based CRM Tool | Kewal Kishan
17:59
Kewal Kishan - Automate Business
Рет қаралды 9 М.
哈莉奎因怎么变骷髅了#小丑 #shorts
00:19
好人小丑
Рет қаралды 55 МЛН
когда не обедаешь в школе // EVA mash
00:57
EVA mash
Рет қаралды 3,7 МЛН
Make Your Own CRM with Excel | Chapter -2
27:33
Sahil Khanna
Рет қаралды 53 М.
Post Reminder using Google Sheets on Email [ Hindi ]
9:18
Sheetomatic
Рет қаралды 3,8 М.
I Built a FREE Sales CRM with Google Sheets (2024)
13:56
CloseDr
Рет қаралды 2,4 М.
How to Create an MST via Google Forms | Step by Step Guide
18:35
哈莉奎因怎么变骷髅了#小丑 #shorts
00:19
好人小丑
Рет қаралды 55 МЛН