Hello community,

I’m having a problem with a formula that I’m attaching below:

Can anyone help me understand how to use the filter correctly? Thanks in advance!

Hello community,

I’m having a problem with a formula that I’m attaching below:

Can anyone help me understand how to use the filter correctly? Thanks in advance!

The function I provided outputs one result.

In cases you want one result, you can always add First() or Last() at the end which will take the first or last item in the list, but I am not sure that is what you need.

I am sorry, but I don’t understand what you are looking for, I am afraid I cannot help you in this scenario.

Hello @Vcarv

Please provide more details about what you intend to do. It is true that having a document is very important to help you, but without context, it can be difficult to understand the whole picture.

From analyzing your document, it seems that you are trying to track the progress of your books. The books are listed in the “Stat” table, while each entry in the “Book of the Day” table is used to update the progress. The “Start Progress” is a manual input and remains unchanged (it represents the initial condition). The “Current Progress” should reflect the most recent progress of that book, correct? In the “Book of the Day” table, when you add a new row, the “Last” column should check the “Stat” table for the current progress and display it, while the “Current” column is 1% more than “Last”. Is this what you are trying to achieve?

If this is your goal, the “Last” column presents a challenge. It cannot simply retrieve the “Current Progress” value from the “Stats” table, as it would update and change the value in the “Book of the Day” table as well. To avoid using any buttons or automation, the formula must look for the previous entry in the “Book of the Day” table (before the current one) and retrieve its “Current” value. If no previous entry exists, it should pull the “Start Progress” from the “Stats” table.

To simplify things, I have made it so that you can only select one book per row in the “Book of the Day” column. While it is possible to work with a list, it would be much more complex, and unfortunately, I don’t have the time to implement that

I am unable to edit your document directly, so I made a copy of it and modified it to implement the changes I described.

Best Regards,

Arnhold

Your formula has 2 problems:

- the type on which you want to filter is an object, while the comparator (thisRow.book) is a text value. There are different ways of solving that, one is shown in this message.
- in your book of the day table you are filtering on the last 7 days, you probably want to do the same in your filter in the stats table.

Your formula would then look something like this:

With the following result:

I’m not sure what result you expect in the other column (progress).

Thanks a lot guys!