-
Constructing URLs to particular rows in sheets
Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink that references particular tasks / rows. The idea is that as the project SmartSheet gets extremely big and with multiple…
-
email data from smartsheet nice visuals
Hello, we are looking for a nice visual way to email data from smartsheet to clients regularly, without having to take screenshots or do anything manually. any ideas of how to do this within an email body? Ideally we would love to email a dashboard but this doesn't seem possible
-
Smartsheet/JIRA Connector: Putting tickets into their sprints instead of in the backlog
We have set up a connection between Smartsheet and JIRA and whenever a row on our Smartsheet becomes a ticket in JIRA, it automatically populates in the backlog instead of within the sprint we've defined within Smartsheet. Is there a way to get around this? I saw a thread that I think was related to this which mentioned…
-
Docusign & Smartsheets
I have a workflow that I have deleted 20 times and it won't go away. I created another it shows up al the only one but when I go to send it it is the one I have deleted. Maybe I have to get rid of my Docusign a/c and start over. I want this to work but maybe the labs aren't that good. Maybe Docusign is a bad product. Maybe…
-
IF Statement for a whole row
Hello! I'm trying to use this if statement: =IF(OR([1]67:[30]67 = "R13"), "500", "") But it's not working when I want it to check the whole row ([1]67 through [30]67) for R13. Is there another way for me to do this statement? Thank you!!!
-
Issues connecting to Smartsheets
Hello, Other areas of the business are exploring the use of smartsheet and they would like to connect our existing analytics tool (spotfire) to use smartsheet as a data source. I've followed: http://smartsheet-platform.github.io/odbc-docs/ and successfully installed the ODBC smartsheet driver, created a DSN, successfully…
-
Index Match with some data returning as Invalid Data Type
I'm using an Index match to pull a certain number. In this column I will get a successful return of a few number then the Error then more correct numbers. Thing is, they are all pulling from the same data set (from an API), and using the same parameters and search values. Why am I getting the Invalid Data Type error?
-
Data Tracker producing duplicates
Data tracker is producing duplicates in my master task sheet. Even if I call the same source file duplicates are being generated. Anybody else experiencing this problem? Portion of JSON file: "testingnew": { "sheetId": "1172822425921412", "src": { "sourceId": "TESTINGNEW", "fileName": "./data/TESTINGNEW.txt", "delimiter":…
-
Google Forms sync - access denied
Hi, i have enabled Google forms sync for Smartsheets, when I click the add-on for smart sheets in a form and it tries to connect to SS, I get this error: Smartsheet Sync: Has been denied access to your data. any help on what is going on here?
-
User Email to update status in smartsheet
Dear Smartsheet users, can I use an email to update a status? We create a ticket in Smartsheet - then we send it to a ticket system. A status update will be provided back to smartsheet and should update the status from new to done. All I found was just creating a new entry in a sheet upon email entry. Regards, Christian
