-
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
-
Changing date within formula
I am looking to find a way to incorporate a changing value to the hours needed per day in order to meet deadlines. In addition i've input task completion % in order to account for the completion rate. My current formula is the following : =IF(ISNUMBER([Man Hours Allowed]3), ([Man Hours Allowed]3 / Duration3) * (1 - [%…
-
Dashboard Tutorials with data
Hi, Can anybody point me to dashboard tutorials that include sample data? I would like to complete the tutorial at https://www.smartsheet.com/how-set-project-management-dashboard-smartsheet however it doesn't include the data that is referred to in the tutorial (unless it is available and i am just too thick to find it?)…
-
Dashboard Gantt for Extended Period Task Prevents Display of Current Dates
For a leadership dashboard, we have a report with a list of current projects. We want to display the Gantt chart on a dashboard. One of the projects began on 8/4/2015. The Gantt timeline begins in August 2015 and can scroll to the week of March 17, 2019. Given that it is May 23, 2019, this is a no-go. Workaround ideas? My…
-
Forms
Hi There, I am trying to create a form to collect data. But I was wondering if the following things are possible: * How do you change the number of options in a dropdown list, e.g. let say I create a form with a dropdown list of 3 options and then later I want to change it to 4 or more? * Is there an option to select…
-
Smartsheet Calendar
Hi, I'm trying to create a calendar in smartsheet that can show five different singular milestone dates for multiple projects so that the calendar reflects milestone type and project name for each. To give background, the dates will more than likely flow in order, but I do not want to show a range. Does anyone have any…
-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
-
Reporting Issue - Not pulling data from a Baseline Schedule
Hi - I have been using reports for a few months and just recently created a few Baseline reports to monitor Project Schedule changes. I have followed the SMARTSHEET method of creating the baseline and creating the report. My issue is that the report will not draw from the baseline schedule. I tried just by itself and no…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Saving & coming back to a partially complete web form
I'm trying to create a web form that allows my users to modify the form that they have previously started. Ideally to save the form and come back to it before submitting the form. Is there any way of achieving this? Many thanks, Neil
