External access to our home's Web servers with Home Assistant and Google Sheets 'https://www.youtube.com/watch?v=qAn9kZdyhaA External access via Google Sheets, daily automation and script to delete rows 'https://www.youtube.com/watch?v=CCDc7U0AtDU
Tag: Google Sheet
Google Sheet – useful formulas
Summarize Your Spreadsheets by Month, Quarter, or Day of the Week 'https://www.youtube.com/watch?v=PmXKxIefsaw Protect or Totally Hide Data Using IMPORTRANGE 'https://www.youtube.com/watch?v=UyBSXgt2_Yg Conditional Formatting Entire Rows | Text or Dates 'https://www.youtube.com/watch?v=WM4hgenP8g4 highlight highest value and lowest in google sheets Row and Column wise. 'https://www.youtube.com/watch?v=kYUaypeaIuw Two Way Lookup, INDEX MATCH, VLOOKUP midnorthsoutheasta111b222c333d444e555666777888 '=VLOOKUP(H7,$A$2:$E$6,XMATCH(I7,$A$1:$E$1),FALSE) 'https://www.youtube.com/watch?v=bTmuQuB1BNU filter based on month … Continue reading Google Sheet – useful formulas
Text formating optins: https://faq.whatsapp.com/556797335179788/?helpref=hc_fnav Google Sheet + WhatsApp Ref:https://www.youtube.com/watch?v=AZzDSr-vV7c&t=618s Selenium + WhatsApp https://medium.com/analytics-vidhya/simple-whatsapp-automation-using-python3-and-selenium-77dad606284b https://dev.to/cyberhoax/automate-whatsapp-messages-35f5 How to download the WhatsApp Business app → https://faq.whatsapp.com/506788753356748/?locale=en_US How to register for the WhatsApp Business app → https://faq.whatsapp.com/2624958974263418/?helpref=hc_fnav About creating a business name → https://faq.whatsapp.com/439359506939557/?helpref=hc_fnav What is WhatsApp Business? →https://faq.whatsapp.com/988069844889223/?helpref=hc_fnav Whatapp link → https://business.whatsapp.com/ Connect with Customers Quickly with WhatsApp … Continue reading WhatsApp
Rishabh's Space 