I have two sheet 1. Schedule 2. Supervision
In Schedule, Examination Date relation with supervision sheet as Supervision=Supervision:DateTimes:multiple
In Supervision Sheet, Name of faculties,
DateTimes 1 DateTimes 2 DateTimes 3 DateTimes 4
I got Inline list for faculties name who have duty on particular Date time. But I want list of faculties who don’t have duty on particulate date time. I use filer as sheen shot. but not display any list.
Appication link https://sal-ems.glideapp.io/
Sheet link Exam Management System - Google Sheets
Thank for help…
Are both of your inline lists using the reference for datetime between schedule and supervision? If yes, then the second list isn’t working because the reference isn’t matching any records in supervision. Instead create another column in both sheets and label it “free”. In schedule, fill every row with “free”. In supervision, create a formula that joins all of your datetime columns together and checks if the joined value is empty. If the value is empty because there are no dates, then fill the “free” column with the word “free”. This will give the second list something to join to and you shouldn’t need to use the filter.
Yes, you are write, both inline lists using the reference for datetime. Please also note one thing more that I want free faculties list for every day every slot i.e. free faculties list for 7/11/2019 10:30, free faculties list for 7/11/2019 2:30… etc
