Automatically Adding a Cell Value to New Tasks

WDelaney

I need to include the sheet name (project name) in each task I add to my timeline. My task name (first row) is designated with the project/sheet name. I created a column called "project" and I am trying to set it up to have the "project" automatically populate with the project column project/sheet name listed on the first row every time I add a task.

Here is the formula I tried but does not work:

=INDEX([Task Name]$1:[Task Name]$1, 1)

Can someone advise how I get this to work as a column formula?

Thanks.

Hollie Green

Instead of putting your Task Name in your sheet put it as a field in your summary and reference that field.

=[Task Name]#