- Hours/Minutes in Project Sheet
I want to be able to make standardized work documents for changeovers/process information. I can't do that in smartsheet due to the lack of hours/minutes in the project sheets (I want to have the gantt chart to the right) Of course I could do something like scale it with the days with 1 day = 1 hr and just ignore the wrong…
- 我试图创建一个公式rying conditions
I am trying to create a formula for the likelihood of a project. I have 2 helper columns and a final column. I am only worried about 1 of the helper columns as I cannot get it to work. The Conditions I am missing is for when a project is planned to start in the middle of a year, I want the % to carry over until 0, and…
- Critical CHAIN Project Management (CCPM) in Smartsheet
Can we do Critical CHAIN Project Management (CCPM) in SmartSheet? If we can, do we need add-ins or can anyone share a template?
- Numbering Duplicates Based on a Date
Please see above a sheet for quote submissions, I want the revision number to automatically number the duplicates of service and contractor based on submission date with the oldest being revision number 1. Currently the Revision Number formula is: =IF(ISBLANK([Service + Contractor]@row), "", MATCH([Row ID]@row,…
- Anyone use Smartsheet for tracking legislation?
I work for a state government agency, and this year we are developing a workspace to help the department track bills of interest/impact as they make their way through our state legislature when the next legislative session opens in January. Does anyone have any examples of what they use for something like this?
- Creating a metrics sheet based off a project intake form
Hello, I'm looking to set up a separate tracking sheet that captures ongoing counts based on our project intake form. I'm hoping to capture: # of requests created by Department (uses a dropdown on the main intake sheet) # of requests per Program (uses a dropdown on the main intake sheet) # of requests by Type (uses a…
- Form Drop Down Populated by Separate Sheets?
Is it possible to connect a drop down column in a sheet to another sheet as a lookup for relevant values? This would enable centralized control of values ensuring they are accurate for form submission. Looking at articles on Data Uploader, this would be too powerful for the specific use case below. Obj: Users are only able…
- Gantt view in reports - parent level view of timing.
Within reports, when in Gantt view, would like to have the ability to see the summary of the gantt chart view (start/end dates) for all of the items within the Group. So see the parent level instead of just the children level at the top (group level).
- Notification options for sheet contributors
I would like to request that Smartsheet add the option to follow specific columns, rows, or proofs. Our team uses the rows to assign projects. It would be extremely helpful to get notified every time a specified row is updated as information is edited or added. It also would be extremely helpful to follow a proof I am…
- Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…
