-
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!
-
QR Coding Tied to Forms
Hello, I'm looking to develop a process for maintaining our mechanical equipment. Ideally a Technician could scan a QR code that would link them to a list of form links. (Each piece of equipment requires 3-5 types of maintenance, requiring 3-5 separate forms) When Creating form links, can they be renamed? Thanks
-
VLOOKUP or INDEX
Dear all, I'm trying to use smartsheet as a Resource Management tool, unfortunatelly we haven't get 10,000ft yet. so what I'm doing is to assign the resources that we need in each project: Project Manager and Allocation % Business Analyst and Allocation % Tech Leader and Allocation % A person can be in different roles…
-
Calculation Sheet for multiple sheets
Hi Guys I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations,…
-
Reporting a date range from multiple sheets
Hi! I have multiple projects (housed in individual sheets) that have varied dates for the same deliverables. At a leader level, I would like to display the range of those dates for key deliverables. I am doing this across a large number of sheets (10-50), so ideally would find a solution within the reporting function…
-
Calculate percentage complete on a project based on time elapsed
I need help to finish a schedule for projects based on time elapsed. The current formula that I am trying to use has a Datedif formula but I don't think Smartsheet supports that. Any ideas or assistance would be helpful? =DATEDIF([Projected Start Date]@row, [Projected Finish Date]@row,[Actual Finish…