-
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.
-
Is there a way to show which reports are built off a sheet?
Hi there, I saw some discussion about this a few years ago, but as an admin, is there any way for me to create a list of reports that use a given sheet as a source? For example, for sheet A, can I pull a list of all reports that use Sheet A as a source? Thanks! Jackie
-
Modified "Report" for client
I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit. I was successfully creating cross…