-
Data Values Not Scaling
Can't figure out what I'm doing wrong. The horizontal axis won't let me scale to data values - option is grayed out so all the values are pushed to the top. In the first column the 86 should be in the blue, the 7 is for the red and the 30 should be in the orange. The vertical axis allows for scaling but it doesn't do…
-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
Automation, Reports and Projects
Hello, I'm trying to find a way to automate my Reports. I want to create a Report that uses an entire folder under Data. So that when I add a new sheet to that Folder the Report automatically updates and I don't have to modify the Report after every new sheet. Another automation I would like to do is create a site…
-
Sales Formulas- Revenue by month and deal total by month
HI everyone, I am trying to create three formulas on a sales pipeline. The first is I am trying to track for the month of July how many deals we have that are opportunities. Then I am trying to track for the month of July how much revenue in deals we have that are in the opportunity stage. I then want to be able to track…
-
Auditing Workspace Permission Changes
Is there a way to audit what changes were made and by whom for a Workspace? The activity log feature seems to only apply to sheets, dashboards, etc. Use Case: Permissions to a workspace have changes. I want to know who made the changes and when.
-
Report Developing - Removing "Header" task
Hello all, I am trying to see if there is a way to remove those "header" tasks from reports. I ask this because it captures dates from the sub tasks and therefore becomes duplicative in a report. I have colored these lines so its easy to overlook them now but it would be lovely to have a way to remove them completely. For…
-
Resource Viewing in Calendar View
Good afternoon We have resources that we have assigned to tasks for the next few months, booked out. How are we able to see our resources in calendar view?
-
My - Smartsheet Wish List 1 Automatically update Column names in reports when changed
Hi, When you change the name of a column in a sheet it will adjust the formulae no problem, however it does not update them in any reports being run from the sheet. Please can this be looked at as it is extremly time consumming going through all your reports just to delete a column that is wrongly named and have to re…
-
Showing Only the Parent Rows in a Dashboard Chart
Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(Ancestors(row))". This gives me a 0,1,or 2 based on how many ancestors the row has. But I'm…
-
Formula takes a few seconds to populate after the sheet is opened
What could be the root cause for a formula not populating until a few seconds after opening a worksheet? I built a formula off of a contact cell that references a roster to show an individuals manager but unlike all the other formulas in the sheet, this one takes a few seconds to calculate, it is throwing off my reports as…