Search a data column and return the most recent past Saturday.
Options
Answers
-
Let's try working in the DISTINCT function:
=LARGE(DISTINCT(COLLECT({Week}, {Week}, @cell <= TODAY())), 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!