-
Managing user permissions for OneDrive folders in Smartsheet
Hello - I am new to Smartsheet, so I have A LOT to learn! Since attachments are not stored locally in Smartsheet, I need to save files requiring updates in OneDrive. Rather than maintaining OneDrive access separately, is there a connector that will allow me to manage access to OneDrive based on contacts that I have invited…
-
Capturing a Total Count to display in a Dashboard
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "Yes"),in a separate SmartSheet, and then creating a Metric Widget within the Dashboard to…
-
Managing and Reporting on Multiple Projects Effectively
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocused on what I’m trying to do that I’ve missed it. I’m looking for a way to manage and…
-
Request Tracker Form
Hello, I have a couple of questions. I am looking for the formula in the "estimated days to completion" column. It doesn't appear to be included (Screenshot 1). Also, how do I reset the request ID numbering to start at 0 again (Screenshot 2) ? I tried deleting the rows and that seemed to cause all sorts of problems. Thanks…
-
Colors for chart widget not preserving settings
Hi all! I am fairly new to Smartsheet but have been taking training where I can to get up to speed. I'm stuck on one particular issue and I'm hoping someone can help. I set up a couple of donut chart widgets to track task status for a couple of sub-projects. These charts get data from a metrics sheet I set up. The idea is…
-
Predecessors - Auto populate dependencies
I am looking for a way to Auto populate/adjust Dependency length on my predecessors. To further explain: I have my projects setup with multiple Widgets. Each widget starts based off a lag time from the start of the widget before it. IE: This is representing that mod 1 and 2 start on the same day, and mod 3 and 4 start on…
-
Request Tracker Form
In Request Tracker, How can I change the default value of department and Request type? How can I put the department and request type in this form?
-
Masterplan
Dear All, Our program consists of 5 sub projects and each of them have their plan. All of these individual plans need to be rolled up into a consolidated master plan that would finally track the inter-dependencies and the critical path. I have read previous posts to use the cell linking feature as well as using the…
-
Row report with spreadsheet summary columns - Relatório de linha com colunas do resumo da planilha
In the row report create the possibility to include columns with information that are in the summary of the spreadsheet. For example in the summary of the spreadsheet we have the fields start date and responsible. Allow the creation of a report of project lines with the tasks of each project, project start date and…
-
How do I track incoming emails in a Smartsheet?
We are getting slammed with inquiries to our info@ gmail address. I think there's a way to send all those emails to a Smartsheet so I can assign, triage, and track our responses.
