-
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…
-
Click on Cell Value to Trigger Search
Leverage Smartsheet's search feature by directly clicking on a cell value. Rather than copy-pasting the value into the search box, I'd like to be able to essentially treat the cell value as a hyperlink that when clicked opens the search results listing all rows with that value. Either via a directly click on the cell value…
-
Click on Cell Value to Trigger Search
Is there a way to leverage Smartsheet's search feature by directly clicking on the cell value? Rather than copy-pasting the value into the search box, I'd like to be able to essentially treat the cell value as a hyperlink that when clicked opens the search results listing all rows with that value.
-
Linkage Between Form and Report
Good afternoon, I am trying to create a function within a form that allows the form user to view prior Notes for repeat customers easily. Currently: All customers have a "Note" entered as part of their form. I have added a checkbox onto the form that asks "Is this a returning customer?" When checked, logic is set up to…
-
Owner/Admin View for Workspaces (Hide unused Workspaces)
As our company admin for Smartsheet, I typically deploy all-new Project Workspaces - this provides me with the opportunity to assist team members if they become stuck, or have an issue; I can then problem-solve with them within their workspace. This leads to an issue where I have many, many Workspaces visible, of which I…
-
Auto-Numbers and using them to seach in smartsheet and pull up rows
Hi All, Is there some nuance I'm missing with using auto-numbers to search in smartsheet? I have a sheet with an auto-numbers column, and a form that's inputting data. Currently using auto-numbers in search isn't pulling up any results even though the ref used for the search is there in the sheet. This is the reference…
-
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 =)