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!
Sorry, it’s [Date]>today()-1 that I’m using elsewhere.
Assuming your Courses table has a [Date] column, something like this should work:
SELECT(Courses[Course2],
AND([Public|Private] = “public”, [Date]>today()-1))
@RezaRaoofi YESSSSSSSS! I had ‘AND’ in the wrong place. Thank you! I’ve spent way too much time trying to figure that out.
You’re welcome @Jayne_Hawkins
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |