Get slice to display lowest results

[David_Taylor]

Hi Appsheet Boffins,

Struggling with a slice expression i’m hoping someone can help me with.

I have 2 tables “Projects” and “Next Actions” now a Project can have many Next Actions. I have created a Column in the “Next Actions” table called Project Order every time a Next Action is created it finds the highest value of the last Next Action and increases it by “1”

Please see table image:

I’m currently sorting my slice by [Status] = “Incomplete” but I also need to get the next action for each project (E.g the action with the lowest “Project Order” number) Also I want to show rows where the Project order = 0.

So the Rows numbers that should return are: 3,6 and 7.

Hope this makes sense, more images / information can be provided.

Thanks in advance.
Dave

[Marc_Dillon]

AND(
  [status] = "Incomplete" ,
  OR(
    [project order] = 0 ,
    [project order] = MIN(SELECT( Next Actions[Project Order] , [project id] = [_THISROW].[project id] ))
  )
)

help.appsheet.com

AND()

Are all true?

help.appsheet.com

OR()

Are any true?

help.appsheet.com

MIN()

Lowest item in list

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[David_Taylor]

This almost works but doesnt return all the required rows