-
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.
-
Some clarification to clarify
I have a few questions that I need clarification on: This is a question about multiple selection able to run report and auto counted and group in report I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in…