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 |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |