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