-
Emailing report if cell is changed.
Is there a way to have a report email only if a cell is set in a certain way? I have a report that I want to email but only if there the box marked review is checked. Is there a way to do this?
-
Filtered View in a Reminder
I want to use a filtered view in a reminder sent to all users of the sheet. Two other alternatives if that cannot be done would be to create a reminder in a report, or to stop the SmartSheet from displaying in the standard reminder. The goal is to send a reminder to team members that shows just the current phase of a…
-
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…
