I have a bunch of numbers in a column, I want to find all the rows that include the # 13 in the number. The "contains" filter option does not work. Need suggestions on finding certain subsets of a longer number on the fly.
If these are purely numeric values (no letters or other symbols mixed in), there isn't a way to filter down or quickly find every number that has a 13 in it. As you've found, the contains criteria currently doesn't work with numeric values, only text values. If your numbers have letters/characters mixed with them, then "contains" will be able to find text values that contain the number.
Unless you're able to convert your numbers to text (add an apostrophe to the beginning, or dashes if you're looking through serial/parts numbers in your sheet), then there isn't an easy way in Smartsheet to filter/search for that number.
You may need to consider exporting to Excel when you need to find numbers that have a 13 in them. More on exporting is available here: https://help.smartsheet.com/articles/770623-exporting-sheets-reports-from-smartsheet
Extrapolating from Shaine's post, create a new column.
In that column, type
=[NumberColumn]1 + ""
where [NumberColumn] is the name of the column and row number is 1.
Copy that formula to the rest of the new column.
This will convert your numbers to text.
You can then search / filter on them.
Watch out for weird results. I ran into a bug with long integers using the formula over the weekend and was told, eventually, that it is a known issue.
This is such a basic feature in any sort of spreadsheet application, I can't believe Smartsheet has gotten this far without having the basic filter "contain" working properly.
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.