-
Smartsheet Properties Report
Hello, I am looking for a comprehensive report of all Smartsheets within our account. Specifically, I am looking for a report that lists all sheet Names, IDs, Links, Owner, Admin, etc. Thank you Bess
-
Chart not showing all data when sheet is sorted
Hello, I am encountering an issuing when trying to sort the information in my sheet that is being displayed in a chart. When I sort on the columns that contains a metric that I am displaying it reduces the amount of data being shown. The first set of images is displaying all of the information I want and the sheet is…
-
Master Sheet Connected to Department Sheets - Best Way to Control
Hi All, Looking for some advice on the best way to proceed. I have a Master Sheet that a coworker and me maintain. We would like to break out this sheet into different departments and have their administrative assistants maintain, update and add attachments to their sheets, thus updating the master sheet. Is this best…
-
How can i update details column with On attachment(Excel file) in my current sheet.
Hi Smartsheet Expert, i have a sheet with student data with columns -name, last name, and "comments". there are a lot of records and i have an excel file where it has different columns including "Comments". using automation or data shuttle how can i update comments of specific students in the specific cell of that…
-
Using Partial Data to Create a Report
Hi, I have a Project Plan Tracking document that contains data from several different projects in progress. My question lies in wanting to create a report for one of the aforementioned projects. I will call it Project A The problem lies where I cannot create a report for Project A without including the data from the other…
-
Automated Email Responses
Hello, Is there a way that that Smartsheet will provide an automated email response? For example, there is a Review Column and a Document Column. The Document Column has Document A in a row, Document B in a row, and Document C in a row. The Review Column has a dropdown menu of potential reviewers: Sally, John, Joe. When I…
-
Report filtering for Multi-Select Fields
Hello, We have created a report that pulls from a master sheet. Within the report we have set it up so that it filters for a multi-select field, then groups by the responses in the field. What we are finding, is that the filter works, but it only groups under the first option selected in the multi-select field. What we…
-
Is there a reason why in group management some names are only email addresses?
-
Why isn't the email address pulling via formula from another sheet for "contact"?
I created a Form for operations to fill out when they determine a ship date needs to push out. Since they don't always know who the Project Manager is, I have this information going into a sheet where the project number pulls the PM info from a master project list using the COLLECT formula. But when I try to create the…
-
Red, Yellow, Green Status with Range Values
How do you work with a range value and RYG status balls? For instance, I have a temperature range of 68 to 79. I would like for the RYG to associate as follows: Red: </= 67 and >/= 80 Green: 70 through 77 Yellow: 68 through 69 and 78 through 79 I just can't figure out how to link the ranges correctly.