Oct 18, 2020 ... I'd like to have each name selected from a position's dropdown disappear from the master list, making it easier to see who I still need to find ...
Dec 30, 2021 ... ... excel-drop-down-list-show-different-value.html. So far I have ... ...it uses a GAS (Google Apps Script code) to replace the Name with the Number ...
Jan 26, 2023 ... ... name of the people be the value I can multiply by... I found a video that seemed to be exactly what i wanted but it has to do with Excel ...
Oct 5, 2022 ... For more specific help, and to make it easier for us to develop and test possible solutions, please create a sample sheet we can all work on.
Mar 27, 2024 ... Other than manually typing each dropdown value (in this case, names), is there a way to import a set of names and they will appear as drop down ...
Jul 7, 2021 ... Note that you'll need to customize the tab names, range reference and the "start Column" variable to whatever is the case on your real sheet!
Jan 20, 2020 ... I dont know how to go about making cells add up based on a selected category by drop-down menu. ... Name 1' example, are only required if the name ...
Jan 13, 2023 ... I am trying to add a new name to the data validation rules in a drop down list. I receive a message stating "Dropdown values need to be unique. Please remove ...
Oct 21, 2020 ... I am trying to have a drop down option in Google Sheets that lists peoples names and their corresponding signature image as the output- is this ...
Sep 4, 2020 ... I have a timesheet for work colleagues, who ideally will go to the sheet, and select their name from a drop-down list, which will then populate the sheet with ...
Jun 17, 2023 ... I want to be able to select a name in a drop down box, and next to it show the correct value. I can achieve this with IFS, but I would need to copy/paste and ...
Aug 24, 2022 ... ... drop down option, he cannot be reselected. On excel I used this formula and hid the master list and it worked really well. =FILTER(I4:I27 ...
Jun 17, 2020 ... In the first 4 lines, you need to change the values of the variables to what will work for your situation: File ID, sheet names, and cell ...
Apr 9, 2020 ... If on my sheet A I select the name XYZ, I want this name to be displayed in my dropdown list 2 and 3 on my different google sheets, ...
Jun 16, 2020 ... I can create drop down lists and select single data from this but I want to select data based on two variables - the name of the crewman (in ...
Jul 28, 2020 ... I am trying to create a drop down list based on a previous dropdown selection ie a dropdown that does not have duplicates or previously selected values.
Mar 18, 2019 ... It is best to have a helper sheet that will combine the first and last names in one column and then use "List from a range" as the criteria for ...
Sep 22, 2020 ... In my master Report sheet I have a column for names where each cell is a dropdown (created using data validation on data listed another sheet ...