Google Sheet – Data Validation and Dropdown content
Thank you for sharing the key content with us ( https://www.techrepublic.com/article/how-to-edit-a-drop-down-list-in-google-sheets/#:~:text=Edit%20the%20text%20to%20add,each%20item%20by%20a%20comma.&text=In%20a%20web%20browser%2C%20select,Save%20to%20apply%20your%20changes. )
I have a query :
– If I have the characters present in the cell and wanted to add the dropdown in the same cell range, without losing the existing data present in cell, can I do it in google sheet ?
Example : Column C has three type of data values such as “WIP, NP, DONE”; Now, I want to add the dropdown to that range and if data is already present it should by default select existing value else it will be blank and awaiting the user action. Can we do it by anyway ?