Show next pending task in Summary



I am trying to show the next pending (open) task in Summary, so it will show on my Summary report as well. In the summary report I also want to show the delivery date for that task.

Basically if the previous task is Completed (checked), then I want the next one to show in Summary.

I am trying an IF and VLOOKUP formula but its not working.

Any ideas please?

Thanks a lot!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!