Sheet Title Formula?

Rachel Nielson

Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know that I can have a column on the report with the Sheet Title, but I would prefer this for other cross references as well. Maybe in the Sheet Summary fields?

Andrée Starå

Sheet Title Formula?

Rachel Nielson

Dec 3, 2024

Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know that I can have a column on the report with the Sheet Title, but I would prefer this for other cross references as well. Maybe in the Sheet Summary fields?

---

View Post

Hi,

I hope you're well and safe!

Unfortunately, there isn't a formula, but I usually add or reference the name to the Sheet Summary Section in my client solutions. Then, I reference that field in a separate column, making that formula a column formula.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Andrée Starå

Sheet Title Formula?

Rachel Nielson

Dec 3, 2024

Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know that I can have a column on the report with the Sheet Title, but I would prefer this for other cross references as well. Maybe in the Sheet Summary fields?

---

View Post

Hi,

I hope you're well and safe!

Unfortunately, there isn't a formula, but I usually add or reference the name to the Sheet Summary Section in my client solutions. Then, I reference that field in a separate column, making that formula a column formula.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Rachel Nielson

I can make that work, thanks!!!

Andrée Starå

Rachel Nielson

Dec 5, 2024

I can make that work, thanks!!!

Excellent!

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!