User Profile
kirkBolton
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
How to assign hidden values to specific text in my dropdown data validation that is later sum
How to assign hidden values to specific text in my dropdown data validation that is later sum. I have been trying to figure out a solution to the above where I can create a work schedule that when I add a work shift code, for example S1, then it would be representing 8 hours of scheduled work hours and S2 to represent 4 hours of scheduled work then when I total the 2 cells then I'm suppose to get 12 hours. I know how to create the drop down, just don't know how to assign the hours to each work shift so when I'm summing those cells it is read as numbers even though text is visible. ThanksSolved5.8KViews0likes13Comments
Groups
Recent Blog Articles
No content to show