-
Customizable Date Formatting
Dates only display by region, would be helpful to customize display (MM/DD/YY v MM/DD/YYYY) by preference so that full date can be seen
-
Time Reporting Against Projects
We are looking for a simple method of capturing daily time by hours or percentage for resources that are assigned to various type of initiatives. Reporting of this time is at a initiative task by week, by month, by quarter, etc. We've tried: Timesheet (Grid) by day: Create a sheet for each resource with the initiative as…
-
Looking for Best Practices: Smartsheet Task Management & Analyst Notifications
Hi Smartsheet Community, My name is Chris Miller and I work at Penn State Health as a PM. I’m looking to gather some insight and best practices from others who are using Smartsheet for project planning and team coordination. Specifically, I’m trying to refine how we manage task assignments for technical analysts within our…
-
Character limit for pull-down menu items
Is there a limit to the number of characters for a pull-down menu item? If so, what is that character limit and are there any other limitations such as special character use?
-
Tips & tricks for setting up workspaces
My team would like standardization on how we set up project workspace. In the root of a workspace, I expect we'd have a standard set of sheets for Schedule, RACI, RAID logs, Issues, etc. For folders within the workspace, we might have some kind of sysadmin folder for sheets where we could collect / aggregate metrics from…
-
What is the best practice for referencing data in another sheet?
I currently have a Data Shuttle updating/replacing all cells in sheet 1. In a second sheet I have a formula that performs an Index/Match with the result coming from that first sheet. I noticed the cell history on the second sheet is capturing the first sheet values disappear and then come back in (example below). Assuming…
-
Tracking & Reporting on Project Hygiene
Hi All! I am starting to explore the possibility of tracking the "hygiene" of each project being managed by our team. We have a control center solution so the artifacts all of us on the team are consistent/templatized and capable of collecting data for a rolled-up portfolio view. So I'd like to be able to leverage that to…
-
Seeking Independent Consultant to Advise on Best Practices Using Control Center
Hi, Looking for someone to serve as a Control Center advisor with non-standard blueprints that do not manage programs and projects. Candidate will be an out-of-the-box thinker, providing innovative methods to enhance current structure to meet developing requirements. Would need this resource about 3-5 hours per month.…
-
Allow system owners and system admins to view all assets
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
-
When to use = and "" in COUNTIF formulas
I came across some weird COUNTIF functionality recently in one of my duplicate check column formulas. I wrote some exploratory formulas and wanted to share! Key Takeaways Numbers with leading 0s requires both = and "" Regular text requires "", but = is optional Regular numbers do not require = or "", but work with one or…
-
Best Practices for IT Portfolio Management
Hello Smartsheet Community, I'm brand new to the Smartsheet community and I wanted to get the community's thoughts on best practices on using Smartsheet for IT Portfolio Management. We are planning to utilize Smartsheet in the following ways and have done some work creating a proof of concept: - IT Project Intake Form -…
-
Proactive with Error Messages - Report
Is there a way I can be proactive about error messages that apprear on my various sheets, reports and dashboards? Like provide me some type of report, so I can go to those pages and get things fixed? I would not even know how to set anything up, as there are multiple sheets, reports, dashboards I manage.
-
Program Toolkit: How to rename program through control panel & Keep existing cell links.
I have several program folders with smartsheet templates connected to a blueprint, managed by Control Center. My question is this; How do I change the program name of a folder and its sheets while retaining all existing cell links? Additionally these programs roll up into other sheets for reporting and dashboards, These…
-
Several Master Sheets vs Just One
Hi Smartsheet community, I would kindly ask for your best practices/recommendations to handle the following situation in a large company where we are using the PMO Template for managing IT Projects. When we built the solution, we started with two main files: DataSource → List of demands and details, sourced from our…
-
Organizing lots of Smartsheet
Howdy, I work on a large-ish team (70+ members) where only a 4 of us have Smartsheet licenses; we have developed a lot of tools and sheets using the Smartsheet platform, but because the majority of our team doesn't have the ability to create folders or organize files they are ending up with a long list of lists. We were…
-
Best Practices on Managing Changes to Smartsheet Items
Hi all, My organization uses smartsheet to manage our projects and we're are currently running dozens of projects out of it. We use standard templates we built for our projects that include: sheets, reports, and dashboards. Every time a new project starts up we make copies of those templates and tailor it to the project.…
-
Difference between managed and unmanaged resource in Resource management
Hello everyone, I’ve recently started to use Resource management in Smartshet and I’m still learning how to fully take advantage of its functionalities. I have a few questions, because som things are bit unclear for me and I hope that community can help me. I understand that there are three types of users in resource…
-
Help Article updates May 2025
Hello Community, We’ve published the following new content: Column links overview Create column links Manage column links Dynamic View best practices To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback for each article.
-
Chart widget with AI - Static or Dynamic?
Curious if anyone has had luck with creating charts using AI and adding them to their dashboard and the chart updates when refreshed with data changes in their sheets?
-
What would be the most effective way to add annotative data to a grid view?
Hi all, long time listener and first-time caller, I was unable to physically select the "best practices" category, so this goes here. I work for a home builder, and we have a specification grid we utilize in multiple divisions that are placed around the country. The "spec grid" is organized into each division having their…