-
Column filter not showing results
Hello! I am trying to filter for multiple items in a single column. The screenshot below illustrates the fields I am entering but when I apply it comes back with zero results. The value entered is the exact language as it appears in the cell. What am I doing wrong? Can anyone assist? Thanks!! Adding - Can you filter…
-
API Support to Create and Update Sheet Filters
Hi Smartsheet Community and Product Team, Our team relies heavily on Smartsheet for project management and dashboard reporting in our enterprise environment. We recently encountered a challenge where a critical dashboard widget depends on a "Milestones" filter (a shared filter that shows rows where a checkbox column is…
-
Add Quick Filters on Column Headers in Reports (like Excel)
It would be very helpful if Smartsheet allowed quick filters directly on column headers, similar to Excel. Right now, creating a filter requires multiple steps and saving it, which takes extra time for simple tasks. Having the ability to quickly filter a column by value, number, or condition (directly from the header…
-
Excluding All Categories with 0s from Dashboard Graph
I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater…
-
Stacked bar on dashboard - widget behaviour take you to the sheet with the filter by person
The idea is that by clicking on the contact person listed in each part of the column, the widget behaviour is that it takes you to the sheet with filter to that person and status. I imagine this is possible since the information is already extracted to build the graph, so these actions can be identified.
-
Filtering in Reports
Hi, I want to add a filter on this report that only shows a group of rows if the Sum of that group is over 50. So for example in this screenshot, it wouldn't show the bottom 2 groups. From what I can see, that's not possible. Am I missing something? Thank you!
-
best practices for soliciting input from assignees
I'm tracking project tasks in Smartsheet and can assign tasks to persons within my organization. I also use automation to let those persons know. I want those persons to be able to view and edit their assigned tasks without have to see the full list of tasks. Reports and dynamic views, although great for me as the PM, do…
-
Copy A Filter View
I would like to see an easy way to copy or download a filter view (or many filter views) and use it on similar sheets. This would be very useful on complex sheets where we have many pre-set options available for end users. I imagine it would be similar to the feature that allows an Admin/Owner to copy a Sheet Summary and…
-
Can you uses forms to populate fields in existing rows instead of creating an entirely new row?
Hi all, hope this message finds you well. I'm building a sheet with the purpose of being a 'One stop shop' between our organisation and external parties. So far, I've built a mastersheet with a form for our internal team and two separate sheets with their own forms for the external individuals involved. The aim is for our…
-
Filter for entries not in dropdown menu
A filter to see what entries have been made outside of the drop down menu would be helpful, I know there are gaps in my list so I don't want to restrict the entries but being able to identify what options need to be added would be great. Also if you could sort the drop down menu alphabetically also helpful
-
Dropdowns with multiple levels filters
Please, Do introduce dropdowns whose options are filtered by previous options! This is a massive feature that prevents most of my projects being fully moved to Smartsheet! It would be a great addition that would change the game for lots of us!
-
Report Filters for Duration not working?
Hello, I have a project tracking sheet where we layout target start & end dates for each subtask by using the predecessor and duration columns. I'm trying to create a report that shows when certain critical subtasks are rushed, so when "Task" is equal to "Approval" and "Duration" is less than "3d". I tried filtering by…
-
Setting up a Dynamic View based on a 'Week Commencing'
Currently, the HR team manually pull a list of new starts, transfers and leavers for the on a Friday for the following week and send to a mailing list. We are hoping to automate this (as much as possible) in Smartsheet. Each different case type sits in an individual sheet (so leavers in 'Leavers' etc) currently, but I'm…
-
How saved filters work
I'm requesting that the parameters of a saved filter not be updated when I use that saved filter, add some more filters to dive into the data more, update some data fields, then click save. Intuitively to me that "save" should have just stored the data updates and shouldn't have updated the parameters of the saved filter.…
-
Can Smartsheet Resource Management Schedule be grouped by Department?
In Resource Management schedule, I would like to be able to see all of the projects each department is committed to in a timeline view. For example, I'd like to see Marketing department (projects A, B, C), IT department (projects, A, C, D), etc. It seems like I can only view by people with varying filters. Does anyone know…
-
No Dropdown for the 'Enter Value' cell in my report filter/s listing "Current User"
I'm trying to create a report using the 'Current User' filter feature. However, when I attempt to setup the filter in the report that I just created, there's No Dropdown for the 'Enter Value' cell. I just get a text box. Also, the 'Enter Value' text box has a red outline prior to attempting to type something. Nothing…
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person…
-
Function for "current user" to use in formula?
Good morning, Is there a function of some sort that I can use in formulas that evaluates to the "currently logged in user"? Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter…
-
Filter Groups
How to have a filter in a report that shows line items where: - if doc type is one of 8 values AND ASCP is not blank AND if start is in the past AND (% complete is zero OR %complete is blank) OR - if doc type is one of 8 values AND ASCP is not blank AND if finish is in the past AND % complete is less than 1 i've taken a…
-
Alphabetized Filter Dropdowns
It would be helpful if the "is one of" dropdowns in filters were alphabetized instead of listed in the order of most used. For dropdowns that have many different options, it is hard for team members to find the option they need in a filter when it isn't alphabetized. Example of Today Red (52) Green (43) Yellow (28) Blue…