-
Reporting - Hierarchy functionality
How do you create indents in the Reporting function that was done in the Project Plan? At the moment, when I generate a report it lists a series of tasks but does not create the hierarchy that is done in the Project Plan
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
Sharing Reports
Is there any way to share information on a report without giving employees access to the sheet it's connected to. This main sheet uses forms and may carry confidential information and I don't want them to view the full details of the sheet, just a few important key items on a report. Is this possible? This is in regards to…
-
Gantt view on a dashboard report
I'm trying to include a report with it's corresponding Gantt chart on a dashboard. The report is set to open on today's date. However, in the dashboard the Gantt chart starts in June and I can't even scroll back to today's date (see attached snapshot). Can anybody help? Thank you.
-
SUMIFS based off Status and date?
I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a dashboard that then has a sum of that type of tasks completed during the current month, and the previous month (seperate). The FormData screenshot is the Grid that collects…
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working on building a quotes log where we input a project name in Job Name which then auto fills to the Job Name Master. Next to the Job Name Master…
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
Issue with chart widget on dashboard
I am pulling multiple reports into a dashboard. I am then making charts from these reports. One of the reports, will not measure the same as the others even though the criteria is the same. For example, the bottom % are showing 1% multiple times along the lower horizontal of the page. I want it to match the others which…
-
Formula irregularity
Fairly new to Smartsheet, although I know my way around an Excel spreadsheet. I am trying to create a count of how many reports are submitted per hour on each given day. The reports come in via a Web Form, into the Taxi Rank Data sheet. I have created the following Sheet (see attached jpg) with the following formula,…
-
Visual Gantt with Milestones Embedded
I'm trying to add a dynamic visual Milestone gantt on a Dashboard which lists %progress. This should be dynamic so that it displays real-time updates from the detail schedule that i'm pulling the Milestones from. Any suggestions on what tools are available.