Closest Date in the Past

LJK
✭
Hi,
I am currently building a ranking that I will display in a Dashboard. I need to grab data from another sheet that is the closest in the past to keep it up to date.
Any suggestions for a formula?
Tags:
Best Answer
-
Try something like this...
=MAX(COLLECT({Other Sheet Date Column}, {Other Sheet Date Column}, @cell < TODAY()))
Answers
-
Are you trying to fetch a single row from the other sheet?
By "closest in the past" do you mean the most recent entry as in the date that is closest to the dynamic "today"?
Yanis.
-
Thanks for your support in advance!
I would like to have it dynamic from today.
-
Try something like this...
=MAX(COLLECT({Other Sheet Date Column}, {Other Sheet Date Column}, @cell < TODAY()))
-
Thank you!
-
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!