-
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…
-
Planned % rollup formula giving higher % than % Complete
Hi Community, I’m trying to build a reliable Planned % column that rolls up consistently, so I can compare it against % Complete at the project and phase levels. Setup I created an Old Planned % column that calculates planned progress for each row based on Planned Start and Planned Finish dates: =IF(OR([Planned Start]@row…
-
Critical Path based on a release
I would like to see a critical path on a large project based on a release number. The critical path seems to be only available on a sheet basis. I can use a critical path filter that works great – but again works on a whole sheet. I was thinking about using a Release Number filter and then copying just those rows to a new…
-
Gantt Chart Display and Behavior - Open to today's date mysteriously gets unchecked.
After I have checked Open to today's date for my project setting, it gets unchecked in a couple of minutes. Is anyone else experiencing this? https://help.smartsheet.com/articles/765755-modifying-project-settings#toc-customize-the-gantt-chart-display-and-behavior
-
How to record a date in a gantt?
Hi, I have a question about the Gantt chart. I want to record a date (start date) when a row is added. This will ensure that when a row is added to the Gantt chart, the start date is recorded at the beginning of the Gantt chart, and the other dates are automatically calculated. Is this possible? Regards
-
Accessing Smartsheet sheets shared with non-licensed users
My company has the Smartsheet Business Plan and I have a Smartsheet license. I've created several sheets and shared them with multiple stakeholders who do not have a Smartsheet license. Some have indicated they are having issues viewing the sheets. I've checked their email addresses, and they are correct. Some are…
-
Language Translation Process
Hi Smartsheet Community, We are trying to develop a process within Smartsheet, that essentially allows us to create a repository of processes in English, and once english is entered, it then translates into French, German, Spanish but all on separate sheets. I was thinking about reports, but it doesn't really give us the…
-
👋 Hi everyone, I’m happy to be here!
🏥 Where I work & role I’m a Grant & Development Coordinator at a community-based organization that is also a certified culturally specific behavioral health provider. Our work blends behavioral health, community health services, public health programming, and a cancer support center. 📊 Background & Smartsheet experience I…
-
Automations
Looking to see if anyone else has experienced a similar problem or might have some insight into why the below isn't working right for the team I'm working with. We've setup a grants tracking database that will send automated alerts for various things including if an end date has passed and the grant manager hasn't updated…
-
Tracking changes
Hi, I'm wondering how to track changes that other team members have made in our shared sheets, if someone could let me know how to do this or if there's a report I can pull down, that'd be great.