Metrics with INDEX and TODAY function

nicolee

Hello. I am trying to combine the INDEX and TODAY functions into a formula that will return the value of a row in a column called "Redeemed" if the date in the "Date" column of that row also falls within the last 7 days. I am not sure how to incorporate the TODAY into the formula. How can I make these work together?

Something like this? =INDEX({Redeemed}, {Date}, >=TODAY(-7))

Paul Newcome

Try something like this:

=INDEX({Redeemed}, MATCH(MAX(COLLECT({Date}, {Date}, @cell >= TODAY(-7))), {Date}, 0))

Paul Newcome

Would you only have one date that falls within the past 7 days?

nicolee

Thanks Paul. Yes there will only be one date that falls within the past 7 days.

Paul Newcome

Try something like this:

=INDEX({Redeemed}, MATCH(MAX(COLLECT({Date}, {Date}, @cell >= TODAY(-7))), {Date}, 0))