Show next task from To-Do list on in a cell in another sheet
I created a simple to-do list in Smartsheet. We have another sheet, call it sheet 2, where I would like to place the value of the next to-do that has not been marked as completed and for it to update sheet 2 when that to-do has been completed and move to the next value on the sheet. Essentially, I'm using the to-do list as a Next Step, so Sheet 2 would display the value as a next step. Thank you!
Answers
-
Hi @charlotte_s
You could use an INDEX COLLECT function to display the value of the Name column for the first row where the Complete column is unchecked. Like this:
=INDEX(COLLECT(Name:Name, Complete:Complete, @cell = 0), 1)
For this to work on sheet 2, you will need to replace the column names (shown in bold) with cross sheet references. Are you OK to do that part? The formula will end up looking like this (which whatever names you chose):
=INDEX(COLLECT({To Do Name}, {To Do Complete}, @cell = 0), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!