I am having trouble replicating a formula. It works in one document but now I am trying to use it in another and it is not working. I have a customer table and an invoice table. The customer table has all my customers. The invoice table has all the invoices for 2019 to YTD. In the customer table,…

Dear @anon10352527 A dummy doc is always appreciated, just to be able to debug your actual situation. If I have understood your question well, please find a sample solution embedded: Kindly note that when making a copy of the formula, it sometimes happens NOT to receive the right outcome, always …

Thank you so much!! I will check this out now. Someone else helped as well so between the two of you I think I am set.

@anon10352527 what was the problem?

I only asked as it helps others when reading through the old threads when the solution is noted in the thread. Are you able to let us know what the problem was and what the solution was? :slight_smile:

@Brendan_Woithe the outcome was buttons pushing buttons :point_down: [image] Gmail pack - show date that you clicked the button? @anon10352527 Here’s a quick sample doc that does this:

Help with filter formula

jeo February 11, 2020, 4:08am 7

@Brendan_Woithe the outcome was buttons pushing buttons

Topic		Replies	Views
Last date using Max() - Not working!	11	4569	December 9, 2019
Returning the value associated with a max value in a column Showcase & Tips	8	1971	December 3, 2022
Filter based on most recent value but with another criteria	5	755	March 9, 2023
Laste date before date	3	975	November 10, 2019
Sum all values for the most recent date	1	84	September 19, 2024

Help with filter formula

Related topics