I’m trying to pulling an ordered list into an EMUNLIST via a Vlaid_IF formula
I have a table with the following 3 columns
[Code] = 3 digit code for the course, also the key
[Name] = the name of the course as a TEXT
[Order] = a NUMBER column where each row has a different number from 1 to 18. I want it to order the list so that 1 is at the top
[Addon] = a Yes/No column
So I want a list of [Name] in [Order] order where [Addon] is false
I’ve tried this and also numerous other ways:
SORT(Select(CourseData[Name],[Addon]=FALSE),[Order],TRUE)
The issue that keeps cropping up is - Unable to find column ‘Order’, did you mean ‘Name’?
I’m presuming this is because the Select is just pulling in [Name], so you then can’t use [Order].
I’m presuming I need some combination or Select and Orderby, but I can’t seem to make it work
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |