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
Tag: Google Sheets
Google Sheets – Pivot Table date grouping by month, quarter, day of the week and week of the yearGoogle Sheets –
Google Sheets – Create to-do list with tickbox
1. To add tickbox, go to Data > Data validation . Select Criteria as Checkbox Create new rows of tickboxes. 2. Once tick the event, then it should be strikethrough and the background should be grey. Go to Format > Conditional Formatting . Set values as shown below
Google Sheets – Basics
https://www.youtube.com/watch?v=N2opj8XzYBY SUMIF in Google Sheets with formula examples : https://www.ablebits.com/office-addins-blog/2018/03/15/sumif-google-sheets/ Sparklines in google sheets https://www.benlcollins.com/spreadsheets/sparklines-in-google-sheets/ 3 Ways to Copy Data From a View Only Google Sheets File 'https://gadgetstouse.com/blog/2024/05/01/copy-data-from-view-only-google-sheets/ Google Document URL Tricks 'https://learninginhand.com/blog/google-document-url-tricks
Rishabh's Space 