-
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…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Archiving Final PDF documents outside of Smartsheet through a script in Python
📄 Automating PDF Downloads from Smartsheet Reports Hi everyone, I manage hundreds of documents generated across multiple sheets in Smartsheet. To keep things organized, I use reports to consolidate them — but I often get asked to ensure these documents are also backed up in SharePoint for redundancy. Unfortunately,…
-
I'd like to generate a weekly report from smartsheet.
I use Smartsheet as a trouble ticket tracking tool and need to generate a weekly emailed open ticket status report that list selected fields from open tickets in the report. What is the best way to do that? I understand Smartsheet has a mechanism to do that.