-
Resource Management: Collect Task "Start/End Dates" and Task "Status" Type
I don't see a way to add tags to collect a row/tasks Start Date or End Date, so it can be reported against in the Resource Management Report. Also, my team would like to be able to set a custom date range for the report but have it remain. Such as "Last 7 Days / Next 7 Days" and keep it in place as an option to select.…
-
Have Board view work in Reports
Board view is amazing - I love being able to control what columns my users see. Please allow this to work in Reports!
-
Selecting the "From" when sharing a report as an attachment in email
My guess is no, but is there a way to select who is the sender of a report sent as a PDF attachment in an email comes from? Similar to how you can do this when setting up an automation - it can come from "Smartsheet Automation" or the owner of the sheet or the org. Seems like whoever sets-up the send as attachment report…
-
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…
-
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.