Help with Helper Column For Report

Hello!

I have been using a helper column in my main sheet to assist with some reports. This is how it was set up:

  1. Main Project

1a. indent with each of the specific tasks for that project

For the helper column:

  1. Main Project formula: "=[Project / Task Title]@row"

1a. Tasks formula: =PARENT([Project / Task Title]@row)


The problem that I am having is for one of the project I need sub tasks to 1a and thus the helper column is pulling the sub task's parent row which is just the task. looks like:

  1. Main Project

1a.

1aa


How can I update the formulas in the helper column so the "1aa" or sub tasks call out the main project title (1).


Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!