Creating an ordered list around a Select function

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

0 6 1,708
6 REPLIES 6
Top Labels in this Space