Freeze top row

Josh Boatwright

Freeze the top row for a standing title display

Paul Newcome

Do you mean in addition to the column headers?

Josh Boatwright

Yes. Using Control Center, we create multiple sheets from a template for each new project. Each sheet is named with the project number and the sheet name. It is not practical to add the project name to the project number + sheet name because it would be too long. Instead, the very first row of each sheet in the template is populated with the project name. However, when I scroll down, it is easy to lose track what the project is when I can only see the project number at the top. If I could freeze the very first row, this common description (project name) would be clear no matter which sheet in the project I navigate to. Thank you.

Josh Boatwright

To clarify, each sheet in the project often has unique column names depending on their purpose (plan, budget, resources). Therefore it is not practical to add the project name to the column header. Instead, the Project Name is included in the NOTES column of the first row of each sheet for the project.

Andrée Starå

https://community.smartsheet.com/discussion/comment/463629#Comment_463629

Hi,

I hope you're well and safe!

As a potential workaround, add the information to the Sheet Summary section and open it up as needed or keep it open all the time.

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!

Josh Boatwright

Thank you. Perhaps we could create a Sheet Summary and link the field to the Project Name from the Profile Data. Our Control Center solution does not use Sheet Summaries, so we would need to update our templates to do this.

Andrée Starå

https://community.smartsheet.com/discussion/comment/463636#Comment_463636

Happy to help!

Yes, that's usually what I do in my client solutions. This also simplifies adding the data on each row using column formulas, so it might be easier to report on.

✅ 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!