-
Pull attachment from Sheet
Is it possible to create a form that pulls attachments and sends back to the requester? e.g., I have a sheet completely filled with a column titled "Common Number Criteria", and an attachment that corresponds to each number in the column. If I created a form and send that link url to an outside user, can they type the…
-
Smartsheet connect to Tableau
Hi, I am trying to establish the connection between Tableau and Smartsheet. However, I do not have Admin Access to the smartsheet, And, I am not able to connect/configure ODBC using either username & password or the API Connection. Is this because I have 'single sign on' for the smartsheet or do I need to have the Admin…
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Epic to story issues from Jira
Hey all, I recetnly created a workflow with smartsheet and jira. All the issues seem to be imported with the stories under its respective epic indented. Later, when i linked some issues to its epic in jira and then refresh smartsheet i dont see those stories to get automatically indented under its epic. Do i have to do it…
-
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…
