-
Search not finding data entered via WorkApps
I have a sheet with a form. Last month I added that form to a new WorkApp to make it easier to access by our technicians. It appears that all the data entered after that time isn't showing up when I search for it. It's in the sheet. Data entered before the form was added to the WorkApp is showing up in search. Is this a…
-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
-
How do I create a search function in a sheet?
Hi all, I was wondering if there's a way to create a search function in a sheet or on a dashboard where it will draw specific columns for that material from another sheet. I don't want to share the master sheet with the audience. Thanks =)
-
Search
Hi The search facility is really helpful, however, is there a way to limit the search to the sheet or report that you are looking at? For example I may want to search for a customer in a specific sheet, I want to use the search facility, but it shows where the customer is in all the sheets, not just the one that I am…
-
Enhanced Community Search is Now Live!
Hey Smartsheet Community, The Community Team is excited to announce a new and exciting way to search, giving you the confidence to find exactly what you’re looking for when you need it most. We’ve enhanced our search tool so you can now search for relevant and up-to-date Community posts. In addition to these changes, we’ve…
-
Search on Dashboard
Any suggestions on the following without using Dynamic View: Dashboard has a report Search Box where a user enters data that return the list from the report directly into the Dashboard thoughts?
-
Search on a text string to return all values
Hello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match is not always possible? If so how would accomplish this? Thanks so much in advance!…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Search Bar on Dashboards
We're considering a project in which we will create a series of dashboards within a workspace. Our community would access the main dashboard, select a topic, and be taken to the next dashboard which will contain links to resources and training videos. As we were discussing it, someone asked if it's possible to add a search…
-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
