-
Could we get a setting to lock the gantt chart to 5 years
It would great if there was a setting that would limit the gantt chart view to 5 years in support of shorter projects. Another option that would be even better is to have a start and end date setting for the timeline. It would make it better for printing and sharing.
-
Adding rows and data types with C#
Hi Everyone, I am currently trying to integrated SharePoint data into smartsheet. However, I am struggling with data types and most of the cells do not take my values. I think I have no issue with certain type like TEXT_NUMBER or DURATION but for the other types I am stuck. Can someone show me an example of how to insert…
-
Holidays not showing
Hi. I have loaded holidays under account settings and they are recorded on that admin screen, but they are not being reflected under new projects (in Gantt view). Any ideas?
-
Time based totals
We use Smartsheets for project management. We have about 100 projects of short duration that span over several months. We would like to assign staff to each project then be able to see how many staff members are needed during a given week. I picture a number on the Gantt chart bars that show staff on the bar. Somehow a…
-
CEO interruptions causes delays
My CEO continually interjects his own agenda into the company's workflow. It's been a challenge for many years, and we all know that he won't change. So knowing that we, as a company, cannot tell him to stop, I would like to create some visual that will show how his interruptions cause delays in deliverables of other…
-
Date Calculation \ Automated based upon cell value
Good day Everyone: I have a field set up with automated current date, that is used to calcuate\count the # of days of task duration based on current date and task start date. trying to figure out a way to have Actual duration stop counting once the “Sate” of that task.. reflects “Completed”. Or Actual Duration stops…
-
Multiple reference Formula
Greetings: Trying to create a formula that tracks task duration displayed by "symbol" in conjunction with another condition of the task:... complete, or not started. I was able to get the symbols to show up properly based on calculated duration. However, the bottleneck is related to the formula not picking up a symbol…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
-
Use system column in gantt view
Hi folks, I remember there was a way to use a system column (auto creation date, for example) in the gantt view...the trick was to create another date column and use the =created2 (or the number of the row).... but it will not work (smartsheet will transform the formula in text). I tried the same formula in a normal…
