Hello. It works for me but there’s something extra I wanted to do.
I have a task table with some columns, but the ones that matter for this are Urgency(returns a float falue) and Status(Returns a pre-defined string such as ‘to-do, waiting, done, cancelled…’).
Very well, I want to apply the slice in Urgency and sort it out by the highest value. Here’s the fórmula:
thisRow.In(thisTable.Sort(false(),thisTable.Urgency).Slice(1,3))
It works fine, but it brings all the tasks with all Statuses and I want to exclude some status from the result. However, if I try a different filter, it’ll apply over the previous one that is sliced already. For instance, let’s say that I have 5 tasks:
Task - Status - Urgency
Task 5 (Next)(12)
Task 7 (Cancelled)(13)
Task 13 (To do)(15)
Task 2 (Waiting)(20)
Task 3 (To do) 17
The formula would return the tasks in this order: Task 2, Task 3 and Task 13, and that’s fine. But if I add another filter (let’s say that I want to filter out the status Waiting), then the two combined would return only Task 3 and Task 13. That’s kind of obvious, but what I want to do is filter statuses out and still receiving 3 values in a way that it would return the tasks 3, 13 and 7.
One way to do it (but that I cannot figure out how to apply a formula like this) would be having a formula that:
- Sorts Urgency from highest number to low;
- Filters out some statuses that I do not with to be shown;
- Slice the result of the sort and the filter
Looks easy, but how to implement this in Coda?
Thanks in advance