-
Not all rows are fetching from my Python Script!
I have written a script to fetch all data from a Smartsheet. i am using Smartsheet's get_sheet('sheet_id') method to fetch my Smartsheet, which has 500 rows but i am only getting exactly 300 row objects, after 300 row objects an error like this being thrown "Too large to show contents. Max items to show 300". But the…
-
Adding rows to another sheet automatically
Each time I add one more row to one sheet (Sheet A), I want to trigger the addition of 7 rows to another sheet (Sheet B) . The data in the 7 rows will be driven off of 2 sheets (Sheet A and Sheet C). Sheet C is a static lookup table. Is this possible?
-
Product Key
I need my product Key for run powershell command. Where I can find them?
-
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…
-
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…
-
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…
-
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?