-
Report - Sorting
Hello Community I'm about to pull my hair out with Reports and sorting. I have 24 source sheets, 10 columns selected, no filters or grouping but I want to order my sheets by Order column. The Order column properties are a drop down list (I did try just a text property but that didn't work either). Below are the drop down…
-
Recreating Report in a Sheet
Hello! Our team has a financial tracker and our timesheets in Smartsheet, and I am trying to find a way to link them. The goal is to take the number of hours worked on each project, and multiply them by our average rate to get a rough estimate of our current labor cost. Our reporting also needs to separate time between our…
-
Can I use a workflow to add a Funtion into a column based on other columns data?
This idea is to pull text from one column to another; examplet Below Primary Column: Country Names Child Primary Column: Secondary Project Workflow 1: When a new row is added, place formula to pull text from Child row into new column Workflow 2: When new column is added, place formula to pull data from Parent row into new…
-
Merged: Filters on Reports
This discussion has been merged.
-
Best way to calculate data across 100 sheets with same structure
Working on a project that will have 100 or so sheets with exact same structure. I need an efficient way to be able to calculate data SUM, COUNTS, AVG across 100 sheets in one metric sheet. What is the best way to accomplish this without the need to reference each individual sheet? Is there a way to run metrics on a report…
-
Portfolio Report exists & has current data but isn't showing in either Blueprint for me to edit??
We have 2 Blueprints set up in our Program & we have a Portfolio Report that currently pulls data from 3 sheets (it pulls the same 3 sheets from both Blueprints). We actually only want it to pull from 1 sheet in each Blueprint, so I went to Control Center & clicked through the pages until I got the Dynamic Report Scope…
-
Dynamic View: Option to disable Details tab
In the most of the cases user just need to see report but not details tab, this can be confusing for user
-
Moving Reports and Source Sheets to a new folder under existing Workspace
I want to create a new subfolder under my existing Workspace that already contains Source sheets for each individual with their corresponding Reports. I want to do this because we are adding new company Divisions to the same Workspace. If I do this, will each already existing person's report still have the same URL? The…
-
Tracking "Support Type" Across Events
I am attempting to create a dashboard that pulls from reports/sheets I've made that relate to event support for my organization. There are three types of support that my team offers for events. They are not mutually exclusive. The names of each support type are "Streaming," "Podium Support," and "Photography." On the form…
-
Is there a way to find out if the report is a Sheet Summary or Row Report?
I created a report few days ago and I can't remember if it was sheet summary report or row report. I don't see this listed in the properties of the file. Is there another way I can find out?