-
Reporting filtering
Hello Im trying to sort/filter/group by report by assigned to and no's and then assigned to yes in Alphabetical order so Alex would reflect as 1 no and two yes's and then list Brett as 2 no's and 1 yes. Is that even possible?
-
Convert Report Filter to Sheet Summary Formula
I have a number of reports with sophisticated filters that use an important master sheet as the source. I'd like to have the ability to create a formula from a report that I can paste into the master sheet's Sheet Summary section in a COUNTIF or SUMIF format. This function could be in the File menu under Save Filter As...…
-
My Tasks report please help me troubleshoot!
I have set up a My Tasks report for leaders, and it's not working, which is not good. They don't have access to the underlying sheet - is that why? (in which case what's the point?) It's linked to the right sheet, and is filtered for a contact column where when filtered for "has any of" you see everyone's emails listed…
-
List of reports and sheets used in dashboards and sheets in reports
Is there a way to generate a list of sheets and reports that are used in a dashboard? If not a report, is there somewhere: In the sheet that will show it's used in a report or dashboard In the report that will show it's used in a dashboard or that it uses a sheet In the dashboard that will show it uses a sheet or report
-
Merged: Add Calculated Column Functionality to Reports
This discussion has been merged.
-
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.
-
Merged: Report Advanced Grouping/Organization
This discussion has been merged.