-
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
-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
-
Dashboard/ Report "Current User" Not Updating
Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filter based on "Current User", which is reading the Project Manager Column (set to Contact List). The issue I'm seeing is if…