-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
-
Why can't I filter a report that is shared in a Work App?
I have created a report and shared it in a Work App (Using editor settings). Yet when I preview the report, I cannot use the filter function for this report. Can someone help me out to figure why this is occurring?
-
Generating Automatic Monthly report
Hello, I want to generate a report for for the sum of a dollar value received in a month across various business units. for example: in February, McDonalds 1 credited $800, McDonalds 2 $300, Mcdonalds 4 $500, and so on. I have a helper column already for when the line was closed and a separate column for the dollar amount…
-
Why are all reports within a template folder required in Control Center blueprints?
Is there a specific reason why all reports within a template folder required in Control Center when setting up a blueprint? It lets me set sheets and dashboards as optional but not reports. Is there any good workaround for that?
-
Unable to move existing report(s) to new folder
Hey y'all— I'm new to SmartSheets. And, while I adore it thus far, I keep running into goofy issues I can't figure out. My current issue is: Why can't I move my 2 "Test:" reports into a folder? For organization's I'd like to move them into the folder titled "Amanda's Test Files", but they don't even show up in browse. I am…
-
Row Report - Multiple Sheets - Remove Duplicate Rows
Good afternoon, I am working on creating a row report using multiple sheets of mostly the same data. Starting with sheet one, at sheet 2 the row is 'moved' and more data is added and sheet 3 the row is copied and more data added. I have created the report pulling all the data in, and was able to find a filter successfully…
-
Mode date related features
When a date is changed on an action, we would like for SS to be able to determine if the new date is Before or After the initial date. This would be a real game changer for tracking projects deliverables.
-
Group Management Reporting Capability
I would like to be able to run a group report showing all the group names as well as those who are included within the groups.
-
Ability to add rows directly from within a Report
Reports are a great way to visualize data in the way you'd like: filtered, grouped, summarized, and sorted. The problem is they lack the ability for a user to ADD a row. Example: If I give colleagues a filtered view of data that are relevant to them (say, from an underlying sheet they don't have access to), they can easily…
-
Merged: Feature Request – Enable Copy and Paste for Header Columns
This discussion has been merged.