-
Live Data Search Feature Request
Good afternoon, Would it be possible to create a product that allows users to do a live search on sheets and even possibly aggregate data from multiple sheets to produce given search results. I have already built this through a customized application internally but users are asking to have this capability. Thanks, AJ
-
Webform names don't match to contact list when inputted on form
When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name. So you end up with a new name entry the same as an already existing name in your contacts column. Could they be linked?
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
-
Searching a column in another sheet
Hi, I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or something that can search another column in real-time as I type. An alternative would be a drop…
-
Forgot the name of a tool to use
Hi, I thought I saw something flash up awhile ago about a way to build a site/page or something like that that can be used to keep stuff on per project. Almost like a social media thing. I cannot remember the name of that to look it up so I can learn how to do it. I hope someone understands what I'm trying to get at. :)
-
"Recently Opened" Navigation bar Question
Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be able to bucket them. I understand that this wasn't quite the point and workspaces/sheets were made…
-
find and replace text in an already created update request.
I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse. I would like to remove 'Mary Beth or' Is there a way to do this without opening each request individually and…
-
Countifs with find
I have 2 columns (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down. I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either getting unparsable or invalid This is on a rollup sheet that points to the working sheet.…
-
Comments - Keep important ones on top
Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
-
Filter sheet level attachments
Can anyone tell me how I can filter to show only sheet level attachments (i.e. attachments that are not attached to a specific row but instead are attached to a sheet)? At the moment I have to manually trawl through all attachments in the attachment side window to find them :-(