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
AND(
[status] = "Incomplete" ,
OR(
[project order] = 0 ,
[project order] = MIN(SELECT( Next Actions[Project Order] , [project id] = [_THISROW].[project id] ))
)
)
This almost works but doesnt return all the required rows
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |