Forum Discussion
Custom Condition with Dropdown
Hello,
I'm creating a schedule with easy dropdown list of each shift. I have gotten to the point where each shift has a hidden number value so that I can calculate the total working hours. The issue I'm running into is all but one shift "OFF" has a value of 8, and when trying to set an IF condition it will not let me input all the shifts that are valued at 8. Is there a way to do so, so when I select dropdown I can select any of the shifts and they each equal 8?
2 Replies
If you want to summarize the working hours for multiple days/rows, you can extend the dropdown and formula down: For example, in A2, you can have another dropdown for the next day, and in B2, use the same calculation formula.
If you have a list of shifts for different days and want to calculate total working hours based on your dropdown selections, you can extend your helper column down (e.g., B2, B3, etc.) for multiple rows.
