-
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…
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Wrapping cell text in reports
Hello all, I'm trying to build a Sight with several reports and noticed that I do not appear to have the ability to wrap the text in a report, is this true? It is making the layout of the sight much more difficult since a few of the task names and comments/updates make the report very wide. Plus it is hard to know how long…
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.