Automatically have a project name <<project>> appear on each row

Hernebaybob

I would like to ensure that when an additional row is added to a project plan, the Project Name column is automatically populated with the project name. This name is pulled from the Control Center and is located under the summary section of the sheet. While I am aware that I can manually add the «project» to every row, users frequently leave it blank. Column formula just comes back with error or unable to create.

Protonsponge

Hello @Hernebaybob -

Do you have the project name referenced in your Meta Data sheet? You could reference the meta data sheet where the project name is detailed if you have it in there. For me, I have it in my solution as =({Project Metadata Project Name}) and set as a column formula. This gives me the project name on every row.

Protonspounge (Originally a Deal boy)

Andrée Starå

https://community.smartsheet.com/discussion/123158/automatically-have-a-project-name-appear-on-each-row

Hi,

I hope you're well and safe!

I'd recommend adding a Sheet Summary field, referencing the summary section, and then referencing that and converting it to a column formula in your column of choice.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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!