About 1,213,415 results (5,692 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 ... the dropdown pops up we select our initials and it puts our initials and the current date in the cell , but I havent had any luck making that ...
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 ...
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 original formula in the referenced cells was made up of =CONCATENATE("September ", $B$3+1). This used to work but sheets did an update and ...
Trying to create a monthly reports sheet using a drop down menu ...
https://support.google.com/docs/thread/183182923/trying-to-create-a-monthly-reports-sheet-using-a-drop-down-menu-that-auto-popoulates-information?hl=en Oct 9, 2022 ... I have a spreadsheet for tracking income and expenses.. What I want to do is create a monthly overview sheet that will use a dropdown menu for each month.
Insert smart chips in your Google Sheets - Google Docs Editors Help
https://support.google.com/docs/answer/12319513?hl=en To insert dates, select an option: Enter “@” then under the “Dates section,” select from the pop-up list. Input: @date : Opens the date picker; @today ...
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 ... ... drop-down with the option of blank or "yes". I would like column 2 ... How to create static timestamps in Google Sheets with Lambda Functions.
changing dynamic calendar from Sunday to Monday start using ...
https://support.google.com/docs/thread/228542639/changing-dynamic-calendar-from-sunday-to-monday-start-using-dropdown?hl=en Aug 2, 2023 ... I would like to be able to change this on the fly using a dropdown list where i can either select Monday or Sunday and he calendar will update to show the ...
Multiple arguments (date and category drop down list) from one ...
https://support.google.com/docs/thread/11947705/multiple-arguments-date-and-category-drop-down-list-from-one-sheet-to-use-in-another-sheet?hl=en Aug 13, 2019 ... I am trying to create a sheet that will automatically reference transactions from the first sheet, but in more of a calendar format.
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 ... ... 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 ...
Need help for budgeting sheet: Summing up cells based on drop ...
https://support.google.com/docs/thread/26208436/need-help-for-budgeting-sheet-summing-up-cells-based-on-drop-down-menu-selection?hl=en Jan 20, 2020 ... I have made the drop down menu, the goal is to enter a single ... Community content may not be verified or up-to-date. Learn more ...
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 ... I tried making a dropdown list that pulls from 3 cells: one blank, one that says yes, and one that says no. the blank option isn't showing ...
Converting a choice from a drop down menu in a cell to a number in ...
https://support.google.com/docs/thread/38765918/converting-a-choice-from-a-drop-down-menu-in-a-cell-to-a-number-in-sheets-to-be-totaled?hl=en Apr 8, 2020 ... Community content may not be verified or up-to-date. Learn more ... When I make a selection on the dropdown menu, the formula goes away.
Sorting attendance by date with the time stamp and alphabetize ...
https://support.google.com/docs/thread/66025956/sorting-attendance-by-date-with-the-time-stamp-and-alphabetize-names?hl=en Aug 20, 2020 ... From this list, I created a drop-down menu that is in B1. Then in cell A3 is the QUERY formula that will give you the student names and their ...
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 ... Google Sheets does not have the ability to transfer the format from the source data for the Data validation drop-down list. I would suggest for ...
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 advances a day in each cell as it goes down the column.
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 ... I've experienced the same problem when offering pulldowns of dates, where I create a list in the format Dec 01, 2019 and the pulldown shows 12/ ...
How to make a cell reflect the value of a related Cell in a drop down ...
https://support.google.com/docs/thread/8688103/how-to-make-a-cell-reflect-the-value-of-a-related-cell-in-a-drop-down-list?hl=en Jun 25, 2019 ... Hi so Im making a spreadsheet for some date, and trying to keep it ... Basically I wanted to create drop down lists, which I know how ...
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.
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 ... Hi,. I've got a dates column which I would like make out of it a dropdown selection for using with Query later on.
Need help creating a calendar that updates automatically when you ...
https://support.google.com/docs/thread/184821582/need-help-creating-a-calendar-that-updates-automatically-when-you-select-either-sunday-or-monday?hl=en Oct 19, 2022 ... I created a calendar where the dates update automatically based on the Month you select from the drop-down list.