-
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.
-
Issue setting up report for name off Contact List that has no hits yet
Is there no way to create a report pulling off someone in a column's contact list without actually having an instance of that contact being mentioned in the source sheet? For example, sheet ABC has an "Assigned To" contact list column that includes "Bob". However, Bob does not actually have any tasks assigned to him yet. I…
