-
Referencing a detailed sheet from the master project sheet
New to SmartSheet, so I apologize if this is simple but I couldn't find the answer myself. My organization uses a sheet to list all of our projects and under each project is the list of the activities. This is getting unwieldy. Is it possible to list all the projects on a master sheet and have the details on a separate,…
-
Is there a way to pull info from a form submission and enter it into another form?
I have a form I am currently running, that whenever answered, needs to be reviewed by another person. I am currently using the approval workflow, and putting it in the email with a link to a form that the reviewer needs to fill out. Is it possible to take the info given from the previous form and put it in the next one so…
-
Portfolio % complete report of 10 Workstreams, ~60 projects, hundreds of tasks
Hello community! I have a programme with the following structure: 1 Programme with about 10 Workstreams Each Workstream has about 6 Projects, each workstream is a Sheet and has a column called 'Project' ... the Primary Column is the Task Name, a mix of Tasks, Sub Tasks (using indents) and Milestones. There's a % Complete…
-
Weekly completion running report
Hello, I am trying to create a report for our operations teams to track how many assignments they complete from M-F & then have the report reset on the following Monday. I had previously set up their metrics report using the "In the last _ days" filter, but that is inadequate for them since they want to see their weekly…
-
SmartsheetGOV user unable to access Smartsheet U or Center of Excellence
I'm the administrator for our Smartsheetgov account, and I'm having trouble accessing both the Center of Excellence and Smartsheet University. (And the free recordings from Engage 2022.) I was just trying to refer some new users to them, but couldn't verify that access still worked. We had a code for the Center of…
-
Grouping without sorting by that grouping?
I have a row report that I need grouped by one column and sorted by a different column. The grouped column is sorted as text and is showing 1, 10, 11, 12...2, 20,21... The column that I want to sort on is sorted as a number which is correct. Any ideas on how to break what SmartSheets has built in?
-
Dropdown sorting on forms
I found several forum posts where users are asking if dropdown lists can be sorted alphabetically rather than the way the data is listed during design time. I'm having the complete opposite issue. My dropdown lists are being sorted alphabetically although I want them to be populated in the order that the data was added…
-
Can I use dynamic values as column headers?
I've created a dashboard utilizing data from one of my sheets. I'd like to show eight weeks of historical data to establish a trend, which I have sorted out, but I'd like the values in the chart to show dynamic dates instead of static week numbers. Can this be done and what would be the technique I can use? Thanks in…
-
Can I use Dynamic View to control widgets on a dashboard?
I am learning Dynamic view and Work Apps. So far so good. I understand how to create and apply Dynamic Views/Filters on sheets. I thought that it was possible, from the ENGAGE conference, to control widget displays on a dashboard using DV. For example, I would like a dashboard to NOT display certain metrics based on a…
-
Trouble with Auto Number column type. Shows up different in cell.
Hello, I am trying to use the auto number system and am having a little trouble. You can see in the first image that I have programed it and the preview is pictured as well. First cell should populate as C001. From the second image, you can see how it populates in the cell. It is stating with the number C011 instead. Can…