-
Calculating the task completion
I know this must be simple but unfortunately so am I I am managing a project and I have set it up with a fairly standard heirarchy of task (parent) and sub tasks (child). The sub tasks have a number of individual work items associated with them and I want to use the number of individual work items completed to…
-
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…
-
native dynamic drop down functionality- Card View & Reports
I know there are many different discussions requesting dynamic dropdown functionality native in Smartsheet without a third party solution but I feel the need to start another to emphasize the importance. I believe the need makes even more sense with Card View functionality Smartsheet recently introduced…especially in an…
-
Kanban Project management
Hi Would it be possible to have a Kanban view of the projects I have setup? It could be organized easily by have a collumn with the different Kanban collumns as menu items in a dropdown menu. Then, when entering Kanban view all tasks displays as items in the Kanban collumn they belong to. This would alow a flexible…
-
How to automate Harvey Balls based on % Complete Summary Field
Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated. Thanks, Robert
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
Transferring Cell Data into another Cell's Dropdown List
Hello, My campany is sponsoring a walk for Alzheimer's and I'm trying to create two listed with two Webforms for our site. One will allow companies to register their organizations and Team Names and another for individuals to register themselves. Problem is I'd like the field that takes the Team names on the Team…
-
Suggestions? How to manage/track the Smartsheet workspaces and sheets?
Our SS environment is growing rapidly. Any suggestions or tips when it comes to managing all the sheets. I'm thinking about building a sheet registration Smartsheet that captures who reuested the sheet, when, purpose, department, owner.....etc.... Has anyone done anything like this in the past? Thanks Jim
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
Should I have a PM Lite Smartsheet? A One Pager?
This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution in such short amount of time. The beta version of my project template should work for…