Is there a way to find the last non empty cell in a column similar the LOOKUP function in Excel?
Answers
-
Will all of the cells above be filled in? Exactly how are you wanting to use this data point?
-
Hello,
I have a dashboard showing a project list. The projects are defined by individual tasks, we usually do not start a new task until the last one is complete. For each project, I would like to show the status of the current or last task. My workaround is to have separate cell in the project sheet that is referenced to the last task and then link this cell back to my report. I hope these examples help explain what I’m trying do. There is probably a simple way to do this.
Dashboard
Project 2
-
You could use a formula in that Project Status column to automatically bring in the most recent Status Ball.
I would personally add in a Created Date system column, then use this to find the MAX date in that column where the Status is not blank.
For example:
=INDEX(Status:Status, MATCH(MAX(COLLECT([Created Date]:[Created Date], Status:Status <>"")), [Created Date]:[Created Date]))
Then I actually like your idea of a Report to show this, or you could use a Metric Widget directly from the Sheet if you'd prefer.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!