Get slice to display lowest results

David_Taylor · 10-12-2021 07:46 AM

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] ))
  )
)

David_Taylor

This almost works but doesnt return all the required rows