Metrics with INDEX and TODAY function

edited 06/08/22 in Formulas and Functions

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))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!