-
Is there a way to use automation across grids?
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
-
Dashboard report not showing in Desktop
I have a report in gantt view that is not showing in a dashboard online. I'm using Chrome to access. The source sheet, report, and dashboard all are published with read only full permissions. When I pull up the website in view only using the public link, I get the the following... Is there a workaround so that the report…
-
Reference Entire Sheet AND Filter Rows Where Column Value ="Search Value"
I am simply trying to do the following: - Refer to another sheet (ALL ROWS and COLUMNS) with the following conditions: - Where in Column [STATUS] is = "Done" The RESULT should be: - This new sheet shows all rows and columns from another sheet where Status is Done.
-
Limit access to underlying sheets using Dynamic View
In my organisation, I have designed our Smartsheet solution so that all stakeholders use Reports to fulfil their daily tasks, the only department needing to access the underlying data sheets is Project Management. Is there a way using Dynamic View I can restrict access to the underlying sheets to everyone other than my…
-
Looking to see what reports use a sheet
I sheet of data which is used across a number of reports, is there a way from the sheet i can see where its being used ?
-
Is there a way to Add Filters to Pivot Tables?
Hi - I'm in the process of creating a "Request Tracker" sheet with associated reports & pivots to serve up to a dashboard. I want to create a pie chart that breaks down "Request Type" but only for open requests (meaning, the Status is not one of "Completed" or "Cancelled"). So my question is, is there a way for me to…
-
Including Parents in Report
I'm creating a report and filtering by the value in a particular column. However, I would like to see the parent rows as well. In the original sheet, I can create a filter and check the box that says "include parent rows". However, in the report, I don't have that option when selecting a filter. How can including the…
-
Get Month and Year and Group/Sort
I've got a sheet in which sales reps input their daily activity. This sheet has a date column that is required. I'm trying to make a dashboard to track month to month levels of activity. Perhaps I'm missing something but there doesn't seem an obvious way to do this. I've tried making a report to group by month and sorts…
-
Request A Weekly Update Forces 50 Rows of Update. Only Need to Update First Row
HUGE issue. I have a workflow to request an update every Thursday. When workflow is triggered, instead of having only ONE row update, it asks for 50!!!!! This is bad. I tried to lock these rows but still is launching 50 pages worth of request update. ONLY ONE ROW should ever be requested. Period...
-
Account by month
I have a list of accounts that we are migrating to a new platform over the next two years. Here is a portion of my list. I need to replicate a view to something like this slide. Any idea? I have read everything posted online and watched 2 hours of videos on this today and cannot even come close. I would appreciate any help…