-
Calculating Count of Projects by PM by Month
Hi, Trying to create formula to calculate How many projects start in a certain month by each Project Manager - My excel formulas are weak Master sheet has columns: Project Manager is Contact List (does this have to be a Text/Number Column?) Project Start Date - is Date type Column =COUNTIFS({Keller Project Summary - MASTER…
-
Reporting on Activity Log data without exporting to excel
I am looking for a method to query/report on activity log data without exporting to excel and then importing back I into smartsheet. For example: I need to expose via a Dashboard the number of times specific Dashboards and Sheets are being accessed. Currently activity logs are exported to excel; a pivot table is created to…
-
Report vs workspace permissions
Hi all, can someone please verify whether the workspace-level permissions override the sheet or report-level permissions? For example, I have a user I'd like to have Viewer permission on the overall workspace but Editor permission on a specific report. He has Editor permission on the underlying source sheet (located…
-
Feature Request - Cell History Graph
For all of my projects I need to track the overall % complete for the project and individual areas. I currently have Smartsheet calculating this information and displaying as a % in a cell, but I would like to be able to show how the % complete has trended over time. Is there a way to show the individual cell history as a…
-
Creating Summary on the Fly
This may be a dumb question but I have a sheet Orders that is auto-updated every morning via the Data Uploader. So the list of items changes on a daily basis... sometimes the same items are listed and sometimes new items are listed as well. Is there a way I can create a summary sheet or grouping of duplicate items and…
-
Dynamic Views- Wrap Text?
Hi, I created a dynamic view for the first time today, but can't seem to get the text on column headers to wrap in the view; I didn't see any option for adjusting the column width either. Any ideas on how to do this? Thanks!
-
Opening a Report from a Chart Widget
I have a dashboard with a Chart widget. The "Edit Interaction" behavior is set to open a Smartsheet item, specifically a report. Is it possible to open that report in a separate browser tab? This is my second dashboard, and I'm struggling to see how to make that happen. My first dashboard was prior to the last Smartsheet…
-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
Nested Formulas
I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been selected. For instance,we have an "Assigned" column which is just a check box, a column which indicates if that task is complete…
-
Circular / Blocked Reference (Vlookup)
I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved. My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2…