-
Problem with Group By Sheet Name - shows old sheet name
Hello Community members, I want to present team members from several sheets in a single portfolio level dashboard, to show who is a member of what project. The data exists in similarly formatted sheets, one per project, across several projects. I have a report in which I am grouping by their sheet names. I decided to…
-
2 sheet - 1 report
I created a report taking data from 2 sheets. The formats and drop-down menus are correctly captured from sheet 1 but not from sheet 2. I also noticed that the column "sheet name" was created only for sheet 1 but not for sheet 2. I created the initial report with sheet 1 and only after added the sheet 2 to the same report.…
-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
Email alerts on reports?
We have 100+sheets that I have rolled up into a single report that contains due dates for tasks. I would like to be notified if any of those due dates are not met, without having to set an email alert on each of the underlying sheets.
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
Reports in Collections
I have reports in a Collection that include sheets that are not shared. I do not see rows in the report from sheets that are not shared even when I'm sharing the Collection. How do I get around this?
-
Can I export a sheet's shared users list?
Hi, Is there a way to export the users shared to a particular sheet with the user information (name, email)? I don't need the whole account. Just a specific sheet.
-
Weekly Reports - Best Practices or Tips?
We need to send weekly reports in one email that pull information from a few different reports. We have it all on one dashboard, but I don't know of a way to send dashboard summaries by email. And they don't want to go to Smartsheet to view it there - it's got to be in an email. Ideally, they want the information in the…
-
"Submitted_at" in a report that can be pulled at any time
Right now "submitted_at" the time that a resource submitted their timesheet at is only located in the audit log. The audit log can only be pulled once a month and is not an advanced report that can be pulled into SmartSheet. My team would like the "submitted_at" field to be in the timesheet detail report or another…