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

Superhuman Ask the Community

jeo February 11, 2020, 4:08am 7

@Brendan_Woithe the outcome was buttons pushing buttons

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

Help with filter formula

Related topics