-
Search within a Category in SS Community
When using the search feature in Smartsheet Community after drilling down to a category (with 68 pages), the search feature should only search within that category, and not the ENTIRE community.
-
If cell matches string criteria in one column, THEN return value of another column (same row)
Hello all, I have the following problem. In my first Smartsheet under the column "Revised Catalog Release" I want to output a date value if a criterion is meet. Now this is the other sheet I am referencing: In lay man words what I want is: If column "Task Name" = "Packaged Part Catalog Release" then please return the value…
-
How to determine if a row id is in the list of predecessors for any row
Hello, I have a fairly large Project plan with 700+ rows and am new to Smartsheet. My predecessors list for any given task has multiple row IDs referenced (comma delimited) With help from Rob Hagan's post (https://community.smartsheet.com/discussion/formula-determine-row-number), I have created the ROW_ID) column for…
-
New Search UI Oct 31, 2022
The new Search Results UI that was just rolled out is absolutely terrible. Any exact match to the keyword searched does not display at the top of the search results, but rather is buried in the results. Two separate examples attached. First example, the numbers "813" were searched. Notice that the displayed results don't…
-
Sorting and Searching for WorkApps Home Page is now available!
Hi Community, Now it’s even easier to find your favorite WorkApp! Builders and end users can find their app of interest quickly by either sorting or searching for an app by name, owner or date. A new drop down lets you select either all apps, apps owned by you or apps shared to you, with the ability to apply sort/search…
-
The Smartsheet search function no longer provides Primary Column data in the results.
Smartsheets used to provide Primary Column data as part of the search results. It appears that with a recent update this longer works. Search results are nearly useless as one must now click through each result to find the entry of interest. According to this article,…
-
Data Provisioning when Searching
Has anyone else encountered the message "we have to provision your data" while using the search bar? Does this impact the search result and overall functionality?
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Find (CTRL+F) Values in Contact Column
It appears impossible to find values in a contact column using a CTRL+F/Command+F find function. I've attempted searching by the contact name (Joe Smith), contact email (joesmith@company.com), and even the messier value that copies and pastes out of a given contact cell (Joe Smith <joesmith@company.com>). I need to find…
-
Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project. I want to be able to do it for multiple Job…