-
"Has any of" vs "Has all of"
When filtering a report, what is the difference between the option of "has any of" vs "Has all of"?
-
Metric sheet filter for Dashboarding
Hello: I have a Metric Sheet that I use to feed data into a stacked column graph in the dashboard. The Metric Sheet has rows and rows of data each with a Totals column. For those rows with 0 in the Totals, I exclude them in the data for the stacked column graph. I've tried to apply a filter which removes the 0's so that…
-
Filter Not Working in Card View on a Sheet
Hi - My company has a sheet of tasks for employees and it looks like one of the filters isn't working correctly. When Filtered, The All Staff filter has filtered out one person, "Sam the Butcher". I clicked on the drop-down menu and verified that he's the only person filtered out. This is the end of any reference to "Sam…
-
Filter on dynamic view
I created a filter on my dynamic view. Everytime I open the view, the filter is desactivated and I have to active, how can we lock the filter ON please
-
Enhance Smartsheet with 'Current User' Filter Option in Row Report Summary
I would like to suggest an enhancement for Smartsheet that involves refining the Current User filter. It would be beneficial if the filter could include Admins or Owners from viewing the task list if they haven't been assigned any tasks. This feature would enable Admins or Sheet Owners to view tasks even if they haven't…
-
Sort Rows with criteria
It would be great if you could use the Sort Row function with a criteria option also. For Example: If I had a range of open and closed requests that have different due dates. Sort rows by "Due Date" with due soonest showing at the top but only the rows where the closed box has not been ticked, the rows that are "closed"…
-
Row Report Custom Filter: Allow Basic Formulas to used to Filter Data
Current Build: When Creating a row report, you can filter by Column data. Example: "Month = 3" or "Percent > 75%" Concept: I want to be able to apply basic Formulas to custom filter data. Example: Month =Today(-31) or Percent > AVG([Average1]@row, [Average2]@row) This would reduce the amount of times you would need to…
-
Filters in Datashuttle Using Checkbox (True/False)
Some of you may already know this but for several days (weeks if I'm honest), I've been struggling with why the filter in a DataShuttle was not excluding the rows that data issues (i.e. were not checked and cleared to move to the next step). I have the column set up as checkbox and use a formula to check several other…
-
DataTable Connection fails to transfer records when filter conditions change due to time passing
Hello, Some or all DataTable Connections do not automatically transfer data to the destination sheet under this condition: Filter: <Field name> is greater than <#> days from today Today the filter shows no result The next day, the sheet shows no data but the filter shows there should records transferring. If you manually…
-
Automatically add people in Contacts column depending on the Country
Hello everyone, My team has a sheet with Submitter, Country, Recommendation columns. Each Recommendation is related to a Country. According to the Country, the Submitter field would have to be automatically filled with the respective people for the specific country. The Recommendations are added through a form. In…