How to Build a CRM in Google Sheet in Hindi - A Comprehensive Guide
Vložit
- čas přidán 29. 08. 2024
- 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
It was very helpful in creating my own CRM. Thank you so much for this video!
You're very welcome!
Yar cha gaye ho ! Love for Pakistan
Without array formula or copydown, formula will not itself copy down to new cell... I tried with array formula and it worked properly...
great
Very nicely explained
Thank you so much 🙂
Thak you so much......
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
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)
Hi sir simple and smart crm
Thank you very much
No learning experience from this video, content is good but confined to yourself
After ready to these CRM how can I connect with HOUSING, 99 ACERS , etc for automatic leads capturing ??
Using API of 99 Acers
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
There is a history column there you can see the history of remarks
How much u charge for creating one customised CRM for my business?
czcams.com/video/22HDK4tkwsU/video.html
It's helpful for you
Can you please upload this template and give us a link?
Please fill the form.
Ager data jayda ho ye sare formule failed ho jaynge Appscirpt se sahi rehta hai
Yes but formula value and ke baad paste special krdo
can you send link of this sheet? i can make changes accordingly.
Please create it your self with me on this video
Did not find value 1 in vlookup evaluation
please fill form we will call you
Sir ye crm banaya hai but isme lead capture form me kuchh error a Raha hai apki thodi help chahiye
Call me
please collect the contact no in description of the video
Sir i want last 5 remaks for history. how can i add.
Good approach will created and update
@@businesstechnologybyjatingola Sir,have you updated this?Pls share link.
Sheet link do
please create it yourself
Vlookup error
give me the formula
i want to learn plz help us
please see more videos of tutorials
Tumhare video blur hai aur formals bena batye add kardiya apne
ok we will resolve this issue