Timeline for How can we make a field (Cell) value mandatory if another field (cell) have specific value, while submitting the data?
Current License: CC BY-SA 4.0
21 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S May 13, 2019 at 20:01 | history | edited | user0 | CC BY-SA 4.0 |
grammar corrections
|
| S May 13, 2019 at 20:01 | history | suggested | Glorfindel | CC BY-SA 4.0 |
grammar corrections
|
| May 13, 2019 at 19:53 | history | became hot network question | |||
| May 13, 2019 at 19:46 | review | Suggested edits | |||
| S May 13, 2019 at 20:01 | |||||
| May 13, 2019 at 17:20 | comment | added | Rubén - Volunteer Moderator -♦ |
Maybe the question is too broad as you might be expecting guidance on how to set up a data validation based on a custom formula and guidance on how to use Google Apps Script / JavaScript if statement (perhaps even on selecting other alternative statements like switch ). Anyway, I added an answer that might not have enough details. If you need further assistance, please narrow the scope of your question or post one or several follow-up questions.
|
|
| May 13, 2019 at 17:12 | answer | added | Rubén - Volunteer Moderator -♦ | timeline score: 1 | |
| May 13, 2019 at 16:54 | history | edited | Mahhdy | CC BY-SA 4.0 |
Clarifying the question.
|
| May 13, 2019 at 16:40 | comment | added | Mahhdy | Ok, I will rephrase my question. | |
| May 13, 2019 at 16:38 | history | edited | Mahhdy | CC BY-SA 4.0 |
Adding More picture
|
| May 13, 2019 at 16:37 | comment | added | Rubén - Volunteer Moderator -♦ | Thanks for your nice words. Please don't forget to include the @ before a username when two or more users, besides the OP are participating to send a notification. Please add all the important details to the question. By the way adding a "submit" button could help to clarify help users understand what and when is happening :) | |
| May 13, 2019 at 16:34 | comment | added | Mahhdy | Or the validation stage (For being Mandatory) can happen on Submit. I am adding a submit button to the form. I think it would be easier. | |
| May 13, 2019 at 16:32 | history | edited | Mahhdy | CC BY-SA 4.0 |
added 29 characters in body
|
| May 13, 2019 at 16:27 | comment | added | Mahhdy | Hi Ruben, The Google Sheet Hero ;-). Mandatory means if they don't fill that Cell, they Transfer entry didn't get through. For instance After choosing the Transfer a message box asks them to fill new cell, and if they don't do that, the Transfer entry rolls back to "No Show". I also was thinking of a userform type thing so after they chose Trasfer or Late Transfer, a form pops us and asks them New team and New shift and then write it to the Transfer To Column. But Yes The conditional Formatting was my bad, I meant Data Validation. | |
| May 13, 2019 at 15:55 | comment | added | Rubén - Volunteer Moderator -♦ | What doy you mean by mandatory, in other words, what should happen if they aren't filled-up and when should that happen? By the way, the drop-downs are an option of data-validation not of conditional-formatting. | |
| May 13, 2019 at 15:54 | history | edited | Rubén - Volunteer Moderator -♦ |
edited tags
|
|
| May 13, 2019 at 15:00 | history | edited | user0 | CC BY-SA 4.0 |
deleted 2 characters in body; edited tags; edited title
|
| May 13, 2019 at 14:56 | answer | added | user0 | timeline score: 1 | |
| May 13, 2019 at 14:41 | comment | added | Mahhdy | I want the blue cells in above picture, became mandatory and just can accept the values is available in Team column. Also the white Cells in Transferred to Column should be empty. | |
| May 13, 2019 at 14:39 | history | edited | Mahhdy | CC BY-SA 4.0 |
Adding Sample File and Picture
|
| May 13, 2019 at 14:30 | review | First posts | |||
| May 13, 2019 at 19:46 | |||||
| May 13, 2019 at 14:25 | history | asked | Mahhdy | CC BY-SA 4.0 |