Formula for Showing Next Task and Owner in the Parent Row
I'm looking for a way to show the next task and owner of that task in the parent row heading.
The formula is needed in the Parent Row of the Next Task column. It pulls the next task coming up based on date. I'm assuming a second formula is needed for the owner column where it will match the owner of the next task.
Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!