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.