Sign in to join the conversation:
I have a smartsheet with one column not filtering. It does consist of numbers (i.e. 1.750, 21.875, etc) so I tried entering the entire number, but still no luck.
Hi Nicole,
Your numbers might be treated as text, which would make them hard to filter. One way to spot this behavior is if you see different alignment (example image attached).
Numbers are typically right justified, whereas text is typically left justified.
You'll also want to double-click your column header to make sure it's a Text/Number column.
Otherwise, your filter criteria might need some work. If the above doesn't help, you're welcome to reply back with a screenshot of the filter criteria you're using and I can further advise.
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
Random question for yall on a Wednesday.... Doing some workspace audit and reorganization and need to see if there is an easy way to see what sheets are and are not being used. Within an entire smartsheet workspace, are you able to easily see how many smartsheets that are actively using today / updating consistently? i'm…
