Hey, Everyone - I have a training app that I use to register people for courses. The list of courses is a dropdown enum that pulls its information from a list of courses in the spreadsheet. It’s currently set up like this:
SELECT(Courses[Course2], [Public|Private] = “public”)
This shows me the public courses (which I want) but I also need to show current courses ONLY (ie. today’s date or later).
What would I add to this expression to show only courses that are current AND public? I’ve used today’s date -1 to show current courses in other areas of the app, I’m just not sure how to apply it to this expression. Thanks!