User Profile
AdinelB
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Data validation multiple criteria - Ticketing system
Hi, peiyezhu, Well, from your video it looks great. Exactly what I was looking for. There's a lack of experience from my side when it comes to Java Script, so I really don't know how I could get this done. Do you have any suggestion from your side? I'm really looking forward to adopt it somehow if I can have your support on this. 🙂 Thank you for your time!2.7KViews0likes2CommentsRe: Data validation multiple criteria - Ticketing system
HansVogelaar, thanks a lot! I have attached a version of it now. So let's say that from the "Engineer assign" column of the the MainTable we choose Michael from the data validation dropdown list on row number 6 and we change the status to "Work in Progress" When I want to add another task on row number 7 and access the data validation list from "Engineer assign" column, well I expect not to see anymore Michael's name in there because it's associated with a task already (Work in progress status) and he can be selected only if we change the status of its task (row #6) to "Completed" or "Not assigned". So there's a big algorithm that contains Filtering, Vlookup (maybe?) and data validation. Thanks a lot for your effort of answering me!2.9KViews0likes5CommentsData validation multiple criteria - Ticketing system
Hi, everybody, I'm trying to mimic a task system tracker using data validation and filters and I really got stuck. So, each time I select someone to do a task from a data validation list I want that person to not be shown in the next row when I'm selecting the data validation column ( There's where the filtering function works) only if he is assigned to do a task already ( I made a second column called "Status" with a dropdown list that has 3 criteria "Completed", "Work in Progress" and "Not assigned"). Example: So if let's say John is assigned to do something and his Status is "Work in Progress". Well, if I have another task (next row) and I want to select someone to do it, I don't want to see John's name in the data validation list until I change John status into "Completed" or "Not Assigned" Is there any chance to do this in excel? Thanks a lot!3.2KViews0likes7CommentsTime range between a certain time range and how many hours of that certain range
Hello, everybody I'm trying to automate our employee entries and I faced the following problem. So if Employee 1 is working rom 12:00 to 20:00, theoretically it's a 8 hours program so it's no overtime. But what if every hour between 18:00 and 07:00 AM is paid different (better) . What formula should I use to check a time range between another fixed time range 18:00-07:00 for example and how much hours has he been worked from that certain range. In this case, 2 hours. Please be aware that our employee works also night shift hours, between 22:00 current day and 05:00 the upcoming day. This is a tricky range. I guess we should use the MOD Function for this one Thank you in advanced. Any help is much appreciated!Solved6.7KViews0likes3Comments
Recent Blog Articles
No content to show