-
Revision to change tracking
I changed a column to "Locked" this morning and now all of that data shows up highlighted in the track changes view. I wouldn't consider this a change worthy of highlighting in everybody's reports. Can you please remove this type of change from the highlighting filter? The same goes for changing a column format - I changed…
-
Creating a report from a dropdown list value
I am trying to create a report that will pull in all rows that are under a certain value in a dropdown list. However, when going through the report builder, the dropdown list is blank (picture 1) although my actual dropdown list is populated (picture 2). Is this a known issue or am I doing something wrong? Thank you
-
Calculate due date based on start date + either 1 or 5 days
I need to calculate a investigation date which would be 5 days, unless the "foodborne Illness" cell is checked, inwhich case the investigation date is 1 day after the complaint date. This is for a complaint log I am putting together. I want to auto populate the deadline for the inspector to initiate the investigation. I…
-
How do I create a report that groups different sheet data by week, then ordered by date?
We have separate sheets for our different editorial teams -- like this: - TASK 2 (from team 2's sheet) - TASK 3 (from team 2's sheet) - TASK 4 (from team 2's sheet) thanks superheroes! m
-
Improvements to Smartsheet Sights™, Reports, and User Management
We’ve just rolled out a new release that includes improvements to Smartsheet Sights, Reports, and User Management. Note that the referenced Help Center articles below will be updated with information on the new features tomorrow, Sunday (11/13) Let’s take a look at these new features! Sights: A new Title Widget allows you…
-
Unwanted Scroll Bar in Sight
I recently built a sight (2 screen shots included below) and I'm wondering if anyone has come across this issue and if they know of a way to fix it. I have a report widget and for some reason I can't get rid of the scroll bar on the bottom. I would like it to be wide enough that it doesn't need a scroll bar, but, as seen…
-
Blocking Exporting
Hi, Is there currently an option or setting to block a viewer from being able to export data? I cannot seem to find it. Thanks!
-
Hyperlinks to other sheets not working from report
I have a sheet where one of the columns has a link for each row (project) to a detailed project sheet. When I run a report and include the column with the links in the report, the links are not clickable from the report, so users can't get to the other sheets. Is this as designed or is there something wrong with the…
-
Enhance Reports to allow selection criteria that compares two fields within a row
Hi There, I would love to see the reports tool enhanced to allow me to show records where the Projected Closure date on a row is less than end date. We link a field from a planning/revenue projection sheet that shows when the project will be billed with the actual end date of the project from within its project plan. If…
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…