Google sheets, hide/remove data validation dropdown..unless another cell is not empty?
I have a column that has dropdown list with data validation, and its applied infinitely down that column. So I have lots of cells with the little dropdown arrow which is annoying.
Is there a way to remove that dropdown arrow....IF say "Date" or "Name" column is empty? I want the drop to to show only when I have started inputting data to that row, I will never start with the drop down, I start with date. So ideally, as soon after entering the date, the dropdown arrow appears.
Can that be done? Thanks!
Solution
You can remove the dropdown arrows by unchecking Show Dropdown List in Cell on Data Validation dialog:
This will show the dropdown list only when you start entering data to the cell.
- Show all the data that equals in the inputted values of username by searching the inputted values from Data sheet
- Google sheets, hide/remove data validation dropdown..unless another cell is not empty?
- How to copy/move a newly created spreadsheet into a folder
- How to get font size to show up in a cell
- Function gets wrong value when been called Apps Script
- Multiple REGEXREPLACE in google Sheets
- Merging or Combining two onEdit trigger functions
- The csv import script in google sheet does not work with certain csv, why?
- How do I create unique Identifiers?
- Conditionally format Google Sheets cell based on text in a different cell
- Google Sheets - How to sum an operation involving multiple colums if one column is not empty?
- importing from xml to Google Sheets using importxml
- Spreadsheets get unique names but ignore blank cells
- How to use vlookup with values that aren't numbers
- Using ARRAYFORMULA and filtering for different columns based on another cell
- Script to add 2 cells together on multiple rows of a Googlesheet
- How to set a cell value based on the value of two other cells in a for loop?
- query with date equality comparison not giving the same result as comparing using contains
- How to copy row height formatting of one row in google sheets to another row?
- Combine data in a single row
- How to combine rows into columns based on finding unique values and convert it into rows?
- Google Sheet run a formula that was written on a different sheet
- How to show a default current date in a cell in Google Sheet where data validation is used for selecting date?
- Googlesheets SUMPRODUCT with position
- How can I color the increasing and decreasing slopes on a line chart?
- How to count number of non-blank cells (cells that contain text)?
- Google Sheets Conditional Formatting of a column based on formula
- why can't I retrieve my source and values from my google forms after submitting?
- find & replace commas with newline on Google Spreadsheet
- I'm Having Trouble with a Google Apps Script Array to Update Sheet Cells