-
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
-
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…
-
Automatically add people in Contacts column depending on the Country
Hello everyone, My team has a sheet with Submitter, Country, Recommendation columns. Each Recommendation is related to a Country. According to the Country, the Submitter field would have to be automatically filled with the respective people for the specific country. The Recommendations are added through a form. In…
-
Proof be accessible in Smartsheet Mobile App
The mobile app that can be downloaded in Playstore or App Store doesn't have the feature to view/interact with proofs. It would be nice to have this feature since one of the reasons we use the app is for portability.
-
Provide a template for an Automated Workflow Report
Provide a template for a standard Smartsheet Row Report that collects all creations and modifications of Automated Workflows. Include columns for the Last Execution Date/time, Next Scheduled Execution Date/time, Sheet Name for the source sheet containing the workflow, Created By, Create Date, Modified By, Modified Date
-
Visual / Report for data in a multi-value drop down column
Hello! I have a drop down column with 14 options and the ability to allow multiple values per cell. It is a sheet to show different company internal initiatives, when they are happening, and which team they impact. The impacted team is the multi value drop down. I want to create a visual that shows how many things are…