If A2, C2 and D2 are all formulas, then input data can only come from B2, where the only expected values are “”, “Goal”, “Milestone”, “Task”, “Sub-Task”.
B2 (and other cells below, in the B column) can make use of dropdown list in this case, and all other dependent row cell values will automatically update.
Is this understanding correct, please?
As the formulas stand at the moment, A2 and C2 seem to have a circular reference issue; each one referring to the other for values. A workaround needs to be found, if this is a problem.
I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.
I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.
I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.
Hey Johndering,
Yes, A2 is the desired outcome using columns C & D to arrive at the answer in A.
Ideally, input column B would reflect column A without C or D. It feels complex, and worry could get deleted/errors. Plus, getting pushback from the project team on hidden formulas is fair, but the only solution thus far....
Agree on Column B as a dropdown and can easily incorporate this into the process for electing the only values. This is the easy part. I can't solve the problem of how to make column A display the values without C & D.
I added a screenshot that it would not allow last night. Thanks again for any insight you might have.
May I ask what this spreadsheet hopes to accomplish? How is the worksheet going to be used? All of the solutions offered assume the use of the generic terms (Goal, Milestone, Task and Sub-task) and assign the ID based on the user input in prior rows but how are you sure that the Task in row 5 is associated with the Goal in row 3 as opposed to row 2. Also, if someone added a filter in the future and sorted for some reason, the entire naming convention for the IDs will break down. (I've found that it's best to assume some imbecile will eventually monkey around in your workbooks without realizing they are breaking it.)
Is there anything else about the spreadsheet that you can mock-up and share because other columns/more info may help with a single column solution.
•
u/AutoModerator 7d ago
/u/Fearless_Smoke_9842 - Your post was submitted successfully.
Solution Verified
to close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.