-
Data connector cell version information
Howdy, We are looking at attempting to do timelapse analysis (velocity, etc) with the SmartSheets Data Connector through Tableau. There are instructions on how to connect to the table for your sheet data; however, I am unable to locate anything that details how to connect to the cell version information to do time lapse.…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
Parent Relation on Progress %
Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be…
-
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…
