Toggle dates of the month using Data Validation | Month Dropdown List | Google Sheets Shorts
If you have tables in your spreadsheets where you are looking at Day over Day metrics, you can toggle between months and the corresponding dates by connecting them to a dropdown.
After having a separate table with the month's start and end dates vs the month, you can use vlookup to get those values as per the month selected.
This way, the user gets the option to toggle between months, and look at multiple numbers within the same table. This can also be repurposed for different kinds of date analysis on tables.
Видео Toggle dates of the month using Data Validation | Month Dropdown List | Google Sheets Shorts канала TheDataWay
After having a separate table with the month's start and end dates vs the month, you can use vlookup to get those values as per the month selected.
This way, the user gets the option to toggle between months, and look at multiple numbers within the same table. This can also be repurposed for different kinds of date analysis on tables.
Видео Toggle dates of the month using Data Validation | Month Dropdown List | Google Sheets Shorts канала TheDataWay
Комментарии отсутствуют
Информация о видео
16 августа 2024 г. 11:58:25
00:01:01
Другие видео канала
How to use the SPLIT() Function | Text-To-Columns Formula | Google Sheets Shorts
How to use ARRAYFORMULA?| Google Sheets Shorts
FIND() VS SEARCH() FORMULAE| How to use Find And Search Formula | Excel Shorts
SELECT STATEMENT - SQL | Write your First SQL Query | SQL Shorts
Pre Calculated Fields vs Creating Calculated Fields | Excel Shorts
INDIRECT FORMULA SIMPLIFIED| How to use the INDIRECT formula for Beginners|Excel Shorts
How to use COUNTA() and COUNTBLANK() | Excel Shorts
FILTER DATA IN YOUR QUERY TABLE USING WHERE | QUERY FORMULA SHORTS | Google Sheets Shorts
Get Unique Values from your column using DISTINCT IN SQL | SQL Shorts
LOGICAL OPERATORS WITH WHERE | Filtering Data in SQL | SQL Shorts
How to Filter Data using Data Validation and the FILTER() formula | Google Sheets Shorts
HOW TO DO IF-ELSE in SQL? | CASE-WHEN | SQL Shorts
QUERY FORMULA TUTORIAL | Adding Calculated Fields inside the QUERY table | Google Sheets
How to Sort your Data in Google Sheets using the SORT() function | Google Sheets Shorts
Difference between SUMIF() and SUMIFS() | SUMIF() vs SUMIFS() | Excel Shorts
How to use Slicer to Filter Raw Data|Excel Shorts
SQL GROUP BY | SQL Shorts
TEXTJOIN vs CONCATENATE to combine strings| Google Sheets Shorts |
Change Column Names in SQL using the ‘AS’ keyword
USING FILTER FORMULAS IN GOOGLE SHEETS | FILTER() | SORT() | SORTN() | UNIQUE()
