Show the next task due

mccoy_FSI ✭✭✭✭✭
edited 04/03/24 in Formulas and Functions

All I am trying to do is show the next task in the Next Task column that has not be marked completed in the Status Column. I tried a bunch of different Index/Collect and Index match formulas but the best I can do is get it to return a blank. I don't understand why the below formula doesn't work.

=INDEX(COLLECT([Next Task]:[Next Task], Status:Status, @cell <> "Complete"), 1)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!