-
Only want child task ranges in calendar view (start-end date) w/o summary task row ranges.
We have a large project management sheet with several levels of hierarchy and many summary rows and child rows. We want our staff to be able to use calendar view to easily visualize how their tasks lay out over the course of the month and where they may overlap. (i.e., staff can see where they may need to work on two…
-
Is it possible to edit a report from a dashboard?
Hi. We are creating a Smartsheet dashboard for our incoming projects. Each project manager will need to make comments to their respective projects. Is is possible, if we add the project report to our dashboard, that a PM can edit the report from the dashboard and have it save the edits? Thanks, Shawn
-
NETWORKDAYS Concern With Future and Past Dates
Working on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correctly. In this example I have two helper check columns Delta Check 1 and Delta Check 2 provided below. The problem I'm having…
-
Report Filtering on a Cell
Hi all, Is it an option to Filter out items based on 1 cell in a sheet? We have a project plan and there is a cell that designates the entire project complete that is at the top. Is there a way to exclude data from sheets that have that cell as complete or do you have to filter based on an entire column? Thanks for any…
-
Project Plan Slack/Float
This was first raised in 2016 as a missing critical feature. It seems its still not available... has there been any progress in implementing this? Looking to migrate to a collaborative tool but without key functionality this is a non-starter. thanks
-
Timeline for projects
We have several projects with us, and would like to display them all together clearly in a timeline. Unfortunately I can not find a template or anything else for this, can someone help me? for example sth like this: Thanks! Best Dominic
-
Calculating Duration based on Effort and Resource Allocation %
Why has product development ignored the need of real project managers to be able to calculate durations based on task effort and resource allocation percentages? This is one of the most basic needs of a project management tool and SS's response that 70% of PMs say this functionality is not needed is fatuous at best. These…
-
Smartsheet - Procore & Cyberco Sync
We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this subject.
-
The Mythological Product Development Team
Once again, I have gone in search of what I would consider a perfectly logical and necessary function only to find that Smartsheet can't accommodate. When I call customer service, I receive the same answer every time: “We don’t currently offer that function, but we will submit this to our product development team and they…
-
Hide Divide by Zero Error
Hello, I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. Could someone please help? I tried the following =IFERROR(AVG(CHILDREN([Column]@row],""))) Thanks so much!