-
Project Collaborators Schedule Report
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…
-
Duplicating sheets to have different conditional formatting on reports
I have 5 different sheets representing 5 different projects in 1 program of work. So I am creating reports to bring those 5 sheets together to get a program level view. For one report, I want to see timings in a gantt view and color the bars based on the project sheet. However, I can't do this without changing the…
-
How can I preserve grouping in a report in Dynamic View?
Hi. I am linking a report to a Dynamic View. however, I want to be able to preserve the report groupings in Dynamic View. How can I do that? Thanks
-
Aggregating Data (9 sheets for 40 different clients)
Hello, I have 9 identical sheets (obviously data within them differs) for 40 clients that I'd like to aggregate. The clients fall under 3 verticals and those 3 verticals roll up to one division. I have trying to aggregate the data through cross references but somehow have maxed that out (maybe I am approaching wrong?).…
-
How can I make a single row of information appear as a page/single sheet
I have set up my smartsheet I have created a form for data collection into my smartsheet I have automation to check / populate fields But....... I cannot find a way to display a single row, with all this information as a single page to view. This can be in a report but a page per row or culd be a dashboard or........ The…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
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…