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!
Help Article Resources
Check out the Formula Handbook template!