Data Validation in a Different way!

[danish6061]

*This is not an Excel problem, this is Google spreadsheet problem. I am posting my problem here because I have received very helpful solutions on excel through this site, but now I am in a problem with google sheet and I don't have any platform except this, So please help me!

I have a Google spreadsheet that has a list of problems, the resolution to those problems, and the status of completion.
Column G is where the users are to enter the needed resolution to the problem. Column H is where the users indicate the status (with only three options):
* Not started
* In Progress
* Complete

Users should always enter text into column G that explains what the resolution to the problem is. Then they should change the status to indicate it is now either "In Progress" or "Complete".
I have conditional formatting set so the cell in column G is highlighted in bright yellow until something is entered into it, but users are still sometimes changing the status without providing a resolution which I'd like to prevent.

Is there a way to prevent the user from changing the status to "In Progress" or "Complete" until something has been entered in the resolution column. So if they try to change the status without something being entered in Column G (Resolution column), they would receive an error message letting them know they must first enter a resolution before they can change the status.

Is there a way to do that in Google spreadsheet?
Thanks!

 

[jasonb75]

I've just tried this with google sheets so that I could write up the process for you and it appears that it is not possible there after all. I'm going to try a few other options to see if something else will work, but I think that what you want will only work in excel.

 

[jasonb75]

All options that I've tried lead to nowhere, there is a workaround that could be used for validation in a single cell, but not for a column.

I expect that something could be done with script, but you would need to ask for that on a dedicated google sheets forum, as the language is nothing like vba it is highly unlikely that anyone here would be able to help you with that.

 

[danish6061]

Yes Jason, I have a VBA code for excel which is perfectly fulfilled my requirements, but in google sheet, I am unable to do this thing.

 

[MARK858]

I like jasonb75 think that you are very unlikely to get an answer here as you are going to need a Google script and this is primarily an Excel site.

I really think that you will need to post it on a Google sheets forum. There is a link to one below.

Browse the Google Docs Editors Community - Google Docs Editors Community