-
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
-
Sort Report by the Summary result
I am having a report grouped by region and summarized by numbers of process per region. it's only sorted alphabetical by region not possible to be sorted by summary numbers. Easy feature appreciate if it could be existed soon. Thanks team, Shorouk Helmy
-
Merged: Allow Groups in Reports to be sorted other than alphabetically.
This discussion has been merged.
-
Is there a way to crate a custom sort order on reports?
I have a report that includes a "Priority" column (single select - Critical, High, Medium, or Low). When I use the sorting function in the sheet, I think it sorts in the order of the list that I typed in the column properties. However, when you're in a report, the sorting only allows for ascending or descending…
-
Attempting PUT method on Reports "sourceSheets" field... Does anyone know what the API is expecting?
Hello! I am attempting to use the PUT method on a Report to update the source sheets, but cannot figure out how it wants the source sheets to be formatted.. Like what information do I need to put for each sheet in my array of sourceSheets? I am using Powershell. Here is my code so far: $token = <API TOKEN> $reportID = <ID…
-
Copy Sheet Name Hyperlinks to Another Sheet
Hello Community - Has anyone found a way to copy the contents of the SHEET NAME column in a report to another Smartsheet? I was able to do it with Data Mesh but it just delivers the text content, not the hyperlink
-
Sharing reports with data without even view access to the source sheet
Today in order to share data in Reports we would need to provide view/edit access to the underneath sheet / source sheet. That's not exactly what many of users expect from Reports. This is a pretty typical task to have a data frame (source sheet) and using Reports provide access to certain portions of data to different…
-
Grouping causes "name" to not show in export
I have a report that pulls participants under various managers. Each manager has their own report, and the report is sorted/grouped by employee (see image 1 below). The problem I am having is when I export the report in excel or PDF- it doesn't show any names unnder the employee column (see image 2 below). I can't figure…
-
Is there a way to create a "anybody in the organization can view" view
Here is my situation. I am using Smartsheet as an intake tool for my organization. People from across the business come in and using a form, submit an intake request. One of the data elements I capture is the email address of the submitter I would like to create a report, filtered on the current user, where they can view…
-
Is anyone else losing their mind over the changes Smartsheet is making without announcing it?
I don't understand why Smartsheet changed these icons? They no longer match what is used in a Workspace or Folder. When I teach Smartsheet, I use the icons (sheet/grid, report, dashboard, template, folder, workspace) to help people understand at a basic level what Smartsheet is made up of. THESE make absolutely NO sense…