-
Is there a way to search only within a specific column in a sheet?
It would be helpful to be able to filter a search to only look at a specific column in a sheet. Sometimes I know what column the info I am looking for is in but I am only able to search the whole sheet where there might be more than one instance of that information (but in the wrong column). Also, since the search results…
-
Validate from List of Over 20,000 Items
Smartsheet can't swallow more than 20,000 rows, but I need to check for the presence of an item on a list of roughly 100,000. Any suggestions? Specifically, in Smartsheet I want to take action on an item only if the contributor via a form has a US-government-recognized domain in their email address. The list of…
-
Can I turn a table into a heat map?
I have a table with two axes. The table is roughly 15x15, and each cell is an integer value. In Excel, I'd apply conditional formatting and easily turn this into a heat map. Can I do something similar in Smartsheet? Thank you!
-
Filtering Tasks by Date
Hello Community, i'm trying to create a Filter - Current Tasks, on the Project Schedule sheet. The filter would have Start Date less than or equal to Calendar Date and End Date greater than or equal to Calendar Date. The options available are: "In the past", "In the future" - these are not including Calendar Date.…
-
Auto-save changes sheet focus sometimes
I've been noticing that when a sheet auto-saves, sometimes the focus of the sheet jumps to some other spot on the sheet. So I'll be on row 210 or something, and then when it autosaves I'll be somewhere else all of a sudden. I need to see if I can reproduce this somehow, but I was wondering if this is happening to anyone…
-
Move multiple widgets at the same time
I keep running into an issue on Dashboards where if I add a new widget in the middle of the dashboard and resize, the other widgets just stay in their place. I then have to move each widget below to get the spacing correct. Is there a way to select and move multiple widgets at the same time? Thanks!
-
Reoccurring Reports not Launching
I have 3 reports that have been running, sending (Excel, via email) and today, they stopped running. I even went in and tried to send (via an attachment) the reports as "one offs" and they still wont send. Somewhere I could check why they aren't sending? Glitch in the system, why they wouldn't run?
-
Can smart sheet have multiple tabs? Can smart sheet generate custom master planner documents?
Can a smart sheet have multiple tabs? Also, as an event planner, I'm looking for a solution that will allow me to house several planning templates and generate custom master planning documents. Example: Say I have 10 planning templates, but I only need 5 of them for the event I'm planning. I could indicate which 5 of the…
-
Open hyperlink based on selection in a form
I want to send a user to two different links depending on their selection in a form, is that possible? Example: If one person has insurance they click this box and sends them to a link after they fill the form out. and vice versa if they don't have insurance. I know there's a feature to send them to a url after they fill…
-
Stop a spreadsheet from feeding to a Calendar dashboard.
Hi all. I am looking to find out how to stop a spreadsheet (I'm an Admin) from feeding into a Calendar dashboard (which I can view only; owner is on Maternity leave). My spreadsheet shows way too much data to the calendar - if you right-click on any cell in a Calendar row, you can see a ton of sensitive data AND... you can…
