How to pull the most recent status symbol from another sheet?
Hello,
I am trying to pull the most recent status symbol based off of the most recent date to another sheet.
Basically, I am trying to get the yellow status symbol from the 20th to pull into another sheet and once someone creates a new update with the most recent date/symbol, that symbol should be automatically updated from the 20th to the most recent date/symbol.
I tried to use this formula, but it only pulls the green symbol and I need it to collect any color that is most recently updated.
=INDEX({Project Health}, MATCH(MAX(COLLECT({Date}, {Project Health}, @cell <> "Green")), 0))
Hoping you can help! Thank you.
Best Answer
-
Hi @Brittaney Pizzato - You would match the max date against the date column, and you don't need Collect in this scenario, so it could read as =INDEX({Project Health}, MATCH(MAX({Date}), {Date}, 0))
Answers
-
Hi @Brittaney Pizzato - You would match the max date against the date column, and you don't need Collect in this scenario, so it could read as =INDEX({Project Health}, MATCH(MAX({Date}), {Date}, 0))
-
Thank you, Scott! This worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!