About 1,166,403 results (1,905 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 ... ... list in so we can click on it an select who filled the battery. but I also need it to put the date that it was done as well . What I have ...

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

https://support.google.com/docs/answer/12319513?hl=en
Use @ to insert dates more easily · Enter “@” then under the “Dates section,” select from the pop-up list. · Input: @date : Opens the date picker; @today : Shows ...

Data Validation doesn't keep my date format in the drop down list ...

https://support.google.com/docs/thread/173044084/data-validation-doesn-t-keep-my-date-format-in-the-drop-down-list?hl=en
Jul 29, 2022 ... The dates were in a referenced range and created by using a formula because they automatically change with the users input in a different cell ...

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".

data validation dropdown shows date only in mm/dd/yyyy format. I ...

https://support.google.com/docs/thread/91340084/data-validation-dropdown-shows-date-only-in-mm-dd-yyyy-format-i-want-it-to-be-in-mm-yyyy-format?hl=en
Dec 30, 2020 ... Let me explain the issue a different way by not using dates. Let's say you have a list of names and you select these names for the Data ...

When I input a Cell with Contents from the Dropdown list(in the ...

https://support.google.com/docs/thread/137315074/when-i-input-a-cell-with-contents-from-the-dropdown-list-in-the-format-mmm-yyyy-getting-an-error?hl=en
Nov 26, 2021 ... Compare the data collected on Particular Dates or Months where you select the dates or Months from the Drop down List. Column A is the ...

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 21, 2021 ... I would like to have a drop down list which shows all the months of the year, so when clicking on a month it shows the payments that have come in during that ...

VLookup or ImportRange? Why am I getting an error? - Google Docs ...

https://support.google.com/docs/thread/97579961/vlookup-or-importrange-why-am-i-getting-an-error?hl=en
Feb 11, 2021 ... ... spreadsheet. I want the field to be a drop down list with my students' names. And I want to enter a date to pull in data for that student.

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 ...

Drop down list for multiple worksheets in a sheet? - Google Docs ...

https://support.google.com/docs/thread/320638270?hl=en&msgid=320640537
Jan 25, 2025 ... you should see an example there, after you enter a bit of test data. For example, if you select the Monthly Budget template, on the Summary tab ...

Moving Columns Automatically after inserting a new date - Google ...

https://support.google.com/docs/thread/149337508/moving-columns-automatically-after-inserting-a-new-date?hl=en
Feb 4, 2022 ... So the new data in the example list tab can either be typed in or picked by the drop down list. The date is a formula that talks to the Example ...

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 ... ... entered in a sheet based on date, and the drop down list value. I am trying to set up a monthly budget spreadsheet. I would like to be able ...

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.

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.

Google sheet dropdown box not loading - Google Docs Editors ...

https://support.google.com/docs/thread/207515970/google-sheet-dropdown-box-not-loading?hl=en
Mar 23, 2023 ... I have been able to select a drop box in the first column but the ... Based on the screenshot, this was originally an Excel file but has been ...

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

https://support.google.com/docs/answer/12319513?hl=en-GB
Use '@' to insert dates more easily · Enter '@' then under the 'Dates section', select from the pop-up list. · Input: @date : Opens the date picker; @today : ...

Remove "seconds" from data validation dropdown list - Google Docs ...

https://support.google.com/docs/thread/36014947/remove-seconds-from-data-validation-dropdown-list?hl=en
Mar 27, 2020 ... Community content may not be verified or up-to-date. Learn more ... enter =A2+.25, the result will show 2:00 PM (8am plus .25 of a day ...

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 ... The easiest way is to put the date in 2 cells, highlight both of them then drag.

How to add a number that meet 2 criteria - Google Docs Editors ...

https://support.google.com/docs/thread/83884999/how-to-add-a-number-that-meet-2-criteria?hl=en
Nov 18, 2020 ... First, I have on sheet 1 a list of all my months of the year with some events that happened classified by date. This event have 2 drop down ...

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? ... put a space after the comma or not when listing multiple ...