I have a set of locations, each with a set of shifts. However, the shift times are different on the weekends versus weekdays. I have the first dependent dropdown Valid_If for Location working correctly. I also have the expression to validate if the shift date entered is a weekday or weekend.
I’ve created my Shifts entity table with 3 columns:
Location, Weekend/Weekday, Shift
Location1, WD, 8-12
Location1, WD, 12-5
Location1, WE, 9-1
Location1, WE, 1-6
Location1, WD, 9-2
Location1, WD, 2-7
Location1, WE, 8-1
Location1, WE, 1-4
This is the expression I have so far, but I can’t figure out how to make it work:
IN([Shift], SELECT(Shifts[Location], [Shift].[Weekday/Weekend] = IF(IN(WEEKDAY(TODAY()),LIST(1, 7) ), “WE”, “WD”)))
What I want is for the Shift dropdown to include all Weekend or Weekday shift times for a location based on the shift date that is entered above.