-
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…
-
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…
-
hyperlinking to a folder and or file on our local network drive
I would like to hyperlink a folder to our company shared drive from smartsheet. I keep getting the error message "Invalid URL" I have seen from other comments that this is an issue, is this some feature that may be added by smartsheet? It would greatly benefit the way we could use smartsheets. Thanks for your anticipated…
-
Leading zeros dropped on Python SDK add_rows
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
