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!


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!