About 1,805,265 results (1,060 milliseconds)

Is there a way to use the TODAY function in a dropdown? - Google ...

https://support.google.com/docs/thread/220009050/is-there-a-way-to-use-the-today-function-in-a-dropdown?hl=en
Jun 8, 2023 ... ... put the date that it was done as well . What I have been trying to do is get the =today function to work with the dropdown list. so we click ...

Automatically add "Todays" date when dropdown cell value changes ...

https://support.google.com/docs/thread/228004414/automatically-add-todays-date-when-dropdown-cell-value-changes?hl=en
Jul 30, 2023 ... I would like to use google sheets to track the dispatch dates of items, In column 1 I have a drop-down with the option of blank or "yes".

Insert smart chips in your Google Sheets - Google Docs Editors Help

https://support.google.com/docs/answer/12319513?hl=en
Insert smart chips in your Google Sheets · Add smart chips · Use @ to insert dates more easily · Convert emails, links & more to smart chips · Add dropdown chips.

How can I create a weekly sign-up sheet with a drop-down menu for ...

https://support.google.com/docs/thread/49779716/how-can-i-create-a-weekly-sign-up-sheet-with-a-drop-down-menu-for-date-selection?hl=en
May 29, 2020 ... How can I create a weekly sign-up sheet with a drop-down menu for date selection? I am trying to create a signup sheet for reserving laptop ...

how to insert a drop down calendar in-cell - Google Docs Editors ...

https://support.google.com/docs/thread/123194368/how-to-insert-a-drop-down-calendar-in-cell?hl=en
Aug 27, 2021 ... Right click on the cell you require a drop down calendar, data validation (bottom of list), Criteria - select date, the box beside that select is valid date.

How can I add a date picker? - Google Docs Editors Community

https://support.google.com/docs/thread/198945310/how-can-i-add-a-date-picker?hl=en
Jan 25, 2023 ... I used to be able to add pop up calendar date pickers to columns in Sheets. After the new Data Validation update, I can no longer do that.

Is it possible to add a date picker into Google Sheets - Google Docs ...

https://support.google.com/docs/thread/9683553/is-it-possible-to-add-a-date-picker-into-google-sheets?hl=en
Jul 11, 2019 ... You could use Data Validation to create a dropdown menu with a list of valid dates. The dates included could be generated as a column of values.

Getting a range of data from one sheet, based on it's date, via a drop ...

https://support.google.com/docs/thread/131657337/getting-a-range-of-data-from-one-sheet-based-on-it-s-date-via-a-drop-down-list?hl=en
Oct 20, 2021 ... ... date, via a drop down list. Hi! I'm new to spreadsheets/formulas etc. and am trying to create a monthly finance report for our clients that ...

formatting Date in a drop down list - Google Docs Editors Community

https://support.google.com/docs/thread/19673059/formatting-date-in-a-drop-down-list?hl=en
Nov 13, 2019 ... I have a list of dates in a dropdown list, but i need to to format it to be 'ddd/dd/mm/yy but it will not let me do it, when i click on the dropdown list it ...

Automatically create a series or list - Computer - Google Docs ...

https://support.google.com/docs/answer/75509?hl=en&co=GENIE.Platform%3DDesktop
On your computer, open a spreadsheet in Google Sheets. In a column or row, enter text, numbers, or dates in at least two cells next to each other. Highlight the ...

How do you set up a calendar (date picker) in a cell? - Google Docs ...

https://support.google.com/docs/thread/279831862/how-do-you-set-up-a-calendar-date-picker-in-a-cell?hl=en
Jun 13, 2024 ... Click a cell or select a range of cells; In the Data tab, click Data validation; Click +Add rule; Change the Criteria drop down to Is valid ...

How do I keep the same date when I drag it down the column ...

https://support.google.com/docs/thread/160878398/how-do-i-keep-the-same-date-when-i-drag-it-down-the-column?hl=en
Apr 22, 2022 ... When I grab a cell with the date and pull it down to copy, it ... I know there was a way in Excel, but I can't remember what is was under.

Sheets dropdown formula - display month name+year from a list of ...

https://support.google.com/docs/thread/250138750/sheets-dropdown-formula-display-month-name-year-from-a-list-of-dates?hl=en
Dec 25, 2023 ... I would like that the dropdown will show only the month+year extracted from the full date. I don't want to add a new column which will extract the month+year ...

Insert smart chips in Google Docs - Google Docs Editors Help

https://support.google.com/docs/answer/10710316?hl=en
Add smart chips for people, files, dates, events & places ... To narrow your suggestions, select from the list of suggestions or enter letters, numbers, or ...

Sorting Data By Dropdown Selection - Google Docs Editors ...

https://support.google.com/docs/thread/106905266/sorting-data-by-dropdown-selection?hl=en
Apr 21, 2021 ... To do nothing if there no dropdown selection add an IF to the whole thing. ... By date ascending order if date joined selected. If neither ...

Formula to create a sum of amounts entered in a sheet based on ...

https://support.google.com/docs/thread/65014905/formula-to-create-a-sum-of-amounts-entered-in-a-sheet-based-on-date-and-the-drop-down-list-value?hl=en
Aug 15, 2020 ... ... date, and the drop down list value. I am trying to set up a monthly budget spreadsheet. I would like to be able to create a cell for each ...

How do you create a reactive calendar in Google Sheets? - Google ...

https://support.google.com/docs/thread/8335543/how-do-you-create-a-reactive-calendar-in-google-sheets?hl=en
Jun 20, 2019 ... If I were to select July from the dropdown in A1, is it possible to have all of the days change automatically to the correct dates for July? I ...

Insert smart chips in Google Docs - Google Docs Editors Help

https://support.google.com/docs/answer/10710316?hl=en-GB
You can also insert placeholder chips, time trackers and drop-downs, and use building blocks to track projects, files and more.

Google Sheets: Filter by date range in pivot table - Google Docs ...

https://support.google.com/docs/thread/15963393/google-sheets-filter-by-date-range-in-pivot-table?hl=en
Oct 3, 2019 ... Scroll down to Filters; Click Add and select Date field; Click Status dropdown; Select Filter by Condition; In the dropdown choose Is Between.

How to add a blank option in a data validation drop down list ...

https://support.google.com/docs/thread/5750893/how-to-add-a-blank-option-in-a-data-validation-drop-down-list?hl=en
May 8, 2019 ... Community content may not be verified or up-to-date. Learn more ... I use Excel but German language version, so my formular for the ...