-
Report Layout with Multi-Select Dropdown Column
I am asking for assistance on a report layout. We have 15 Regions. Each Region has small teams. I have some team members that are on several teams. We have a column called “Region” that is a multi-select dropdown column. We like the report that outlines every region’s team members. The report is sorted by region first and…
-
Report Filter - data from 2 sheets
Need help! I have a sheet that references data associated with a Week #. I need to filter this list for a report based on date. I created a 2nd sheet to simply show the dates associated with the week#. How can I in the report filter to show data for the week associated with the week# that starts in next 7 days? The sheet…
-
Report Summary with currency format
Hello, Is it possible to make the overall total summary in a report use the same formatting as the data it is rolling up? For example, I am summarizing costs but the sum at the top is just a number, not formatted for currency, it doesn't even add the commas. Am I missing something in my report configuration? The lower…
-
Report filtering for Multi-Select Fields
Hello, We have created a report that pulls from a master sheet. Within the report we have set it up so that it filters for a multi-select field, then groups by the responses in the field. What we are finding, is that the filter works, but it only groups under the first option selected in the multi-select field. What we…
-
Report with multiple sheets
Hi Smartsheet community, I am working on a report that compiles data from multiple sheets in a single folder. New sheets are added daily. Is there a way to automatically have the sheets selected update for the new sheets added daily instead of manually adding them? Thanks
-
Auto Add or Remove Sheets from Report
Hello, I am creating reports for individuals with multiple sheets to review. I see that I can click on a folder to include all sheets in that folder under the "Where?" section. Is there a way to automatically add or remove a sheet from the report if it has been added or removed from the folder? I keep having to manually…
-
Report filtering when in Card View
I have a Kanban setup using a report pulled from 130 sheets. The report is filtered to only show assignments for 4 people. All of the additional people are filtered out when viewed in grid view but when viewed in card view, there are columns for 2 additional people that should have been filtered out. Any thoughts why this…
-
Weeknumber formula help? Need to calculate the number of times a tasks is completed per week
Hi Team, I have a sheet dealing with people being onboarded. I am trying to count the number of people that "Completed" their onboardings per week. Meaning week 2 in the given year, three people were onboarded. Not sure what the best approach is for this. I would think to create a cross-sheet reference to the sheet above.…
-
CALENDAR APP/Dashboard current user view
I have 2 things I am trying to resolve. I have about 100 external partners who need to see current status of a submission. so Far i am able to display that info in Dynamic View. But I can seem to get the Calander App and Dashboard Widget to show graph. without sharing them to the source sheet.
-
Not able to Group a Report Using Fields in the Report
I have created a report and it's not letting me group the rows by PQE even though it's a field in the report
