-
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…
-
Combine "AND and "OR" with filtering
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is why I am asking: I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions"…
-
Creating a metrics report - Sheet reference not working/displaying criterion
I have a metrics report I am building out for a dashboard, and have a column with a few drop-down options. I am trying to count how many of each category, and it decided it doesn't want to work. I am using the following, and this worked for the status column IE: Showing Started, Not Started, Resolved. But this column with…
-
I'm so happy with this landowner contact log system I designed in Smartsheet
Managing landowner communication used to be one of the most time-consuming and fragmented processes at our company. We relied on Word documents buried in server folders. Logging and reviewing landowner details was slow, only one person could edit at a time, and getting a full picture of a project meant manually opening…
-
Edit reports on a dashboard
Request We need an option for the report widget that would allow users to edit report rows while viewing them in the dashboard. The problem I'm trying to solve: I have a report widget on a dashboard that shows users their assigned tasks. I'm using the widget on a Dashboard to give the users one place where they can see and…
-
Ability to see a detailed log including date an time , for users downgraded users.
Ability to see, report , get a detailed log including date an time , for users who wnet from provisional member to viewers
-
Efficient Monthly Report Data Collection System for Faculty using Smartsheet
I am looking to create a streamlined system in Smartsheet to collect monthly report data from faculty members efficiently. This would include updates on publications, grants submission, presentations, etc. The main goals include consolidating all of this information in one place, providing a user-friendly interface for…
-
How to generate Report from Dropdown list data
I am trying to run a report and group them from the drop-down list data in the sheet. However, when I try to group them out by each list that I have in the dropdown column, it is not available for me to choose. It is also not available for me in the Summary. Anyone know how to use the Group and Summary function in the…