-
Control Center vs Project Web App
Good Morning, Smarties! I am a Smartsheet addict with a wonderful opportunity to recreate existing file-based project management practices and standards in Smartsheet! I am working with teams to understand Control Center's capabilities, and would love to hear how some of you have devised methods to track and compare…
-
Timeline Headers on Gantt Chart
The ability to add headers to the Gantt Chart and Calendar View to represent a grouping of dates (i.e. Sprints, Quarters, Fiscal Year, School Year).
-
Smartsheet Integration With Coupa
Coupa is a cloud-based business spend management (BSM) platform that helps organizations manage their spending across procurement, supply chain, and finance. Coupa provides visibility and control over how companies spend money, optimize supply chains, and manage liquidity. Coupa's platform automates approval workflows,…
-
Automations for time based requirements
Currently we can only use filter expressions and automation that are based on current day or previous day etc. Why can't we filter by past hours or other similar terms? It would add so much functionality to Smartsheet in its various functions, such as project for one when assigning task durations by hours or to filter…
-
Constraint Types in Gantt View
Requesting the ability to use constraint types in a project (Gantt view), similar to the options in MS Project: As Late as Possible As Soon as Possible Finish No Earlier Than Finish No Later Than Must Finish On Must Start On Start No Earlier Than Start No Later Than
-
Merged: Constrain Dates in project management
This discussion has been merged.
-
Target Completion Date not rolling up and duration is way off
Hi, I can't for the life of me figure out why a subsection in my project plan is not rolling up the target completion dates and somehow it's going to take over 100,000 days to complete this section. I've unhidden all cells, double checked the dates, the Dependencies look fine... I'm at a loss. The other subsections are…
-
Editing Start & End Date w/dependencies enabled
I have a worksheet with a Start & End and Project Settings set. I really need the durations and predecessors for the Gantt chart. However, I want my users, ELT, to work only from a report of Dynamic View and they need the ability to edit their dates as needed. According to the article below you can only edit the dates in…
-
Countifs statements for date fields that are in the past
Hi there, I am looking to summarize data from a master sheet for inclusion into a dashboard via a project metrics sheet. Within the master sheet I have an “Opening Date” that is populated when the opening date is decided. I want to populate the Dashboard with the number of sites that HAVE opened each month (past tense).…
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
