Automatically Adding a Cell Value to New Tasks

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.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!