-
Data Shuttle Execution Duration
I'm looking for information on how long your Data Shuttles run. I have one offload, and one upload (first ones - very small - under 50 rows added no deleted, skipped, filtered, no drop downs updated) Looking at a month's worth of logs I see a noticeable increase in execution duration for no apparent reason. What have you…
-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
Customer add/edit sheet rows
I need customers to be able to add rows of information to a smart sheet, and later be able to edit those rows. A scrolling table view interface would work better than a form so users can see multiple records at a time. The sheet needs to be secure so that customers can only see/edit their information, and not be able to…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Hyperlink Target a New Tab
I have created a form that contains a fair number of hyperlinks. These all take users to a site outside of Smartsheet. Is there a way for me to direct those hyperlinks to open up in a new window/tab instead of the same one?
-
Automation of Update Requests
My team each has a sheet on which they need to ask faculty preferences. I have built out an automation to send the request. When it sends, it sends the request for all the rows, not just select ones. However, testing the automation allows me to select which rows I want to send. How do I build this into the automation?
-
How do I contact support when I cannot login and the support phone number tells you to log in...
How do I contact support when I cannot login and the support phone number tells you to log in...
-
Query Formula Help!
I am currently creating a search query that will allow anyone to search for a name and get the corresponding information. For some reason, when I try these different formulas, I am receiving the error message even if the name is correct. I've included my references in the formula as well. Can anyone help with this? Current…
-
Sending email to create a row in Smartsheet
I am looking for a way in Smartsheet, wherein employees will create an email and send to a specific email address and once sent it will automatically create a row in Smartsheet(not using add in). Is there a set up in the email address that I can do to connect it to Smartsheet sheet just like a ticketing system? Is this…