-
Calculating a staged reduction in severity
I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
-
Dashboard vs Master Calendar vs Sights ?
Hi Trying to step away from excel, I am fairly new at using smartsheet and am looking for the best way to view simultaneously multiple sheet to better manage the deadlines of our projects. Being an expeditor, dates are the driving factor to help me guide the multi-disciplinary teams. Since we have multiple deadlines…
-
clock icon in iOS app
We are trying to use the Smartsheet app for the iphone. One of the users is not being able to update in the list view and seeing the clock incon next to each line item. Does anyone know what this means? Thanks for your help.
-
Field Employee time tracking software that integrates with Smartsheet?
I'm looking for a time tracking solution for field employees that integrates with Smartsheet. In our organization we have a master project list sheet that compiles project data for all of our active projects. Our field installers are currently logging their time using T Sheets, they're clocking in/out as well as selecting…
-
Multiple Projects into one Summary
Hi all, I am trying to set up a workspace to help manage multiple clients via projects. I have set up a template set for each project that includes plan, dashboard, key reports. My next step is trying to to roll up each project sheet into one summary for management. I was able to add a checkbox to each template so I can…
-
Percentage Complete Column (Breaks)
Greetings, I've discovered that the % Complete Column in a few of my sheets has broken, is incomplete at calculating the true completion percentage for a project. I suspect this might have happened somewhere along the line of adding/removing rows. Is there any way to see/edit the formula to ensure it is counting all rows…
-
Tasks in Resource View
Is it possible to view the task or sub-task assigned to a resource in a resource view? We use a multi-project sheet to encapsulate schedules and would like to track resources within a sheet as opposed to across sheets. As you can see in the screenshot, the resource view only shows the sheet name instead of the task, which…
-
Issue (or task) list, associated with a project
How do you guys manage issues for a project? I'm wondering a way to attach (or associated) a issue (could be task) list at a project sheet level. Thanks!
-
Column Properties: Not Able to Select Any Standard Option Other Than Check Box
Hi, I have a project queries management smartsheet and one of the Column Titles is "Done". I had chosen "Checkbox" as type of COLUMN PROPERTY. Now I have changed my mind and I want to change the COLUMN PROPERTY from Checkbox to DROP DOWN list. When I right click on Column Heading, I don get EDIT COLUMN PROPERTIES option to…