-
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
-
Is there a way to have the rows automatically sort ascending by date when new rows are entered?
I have a job board created that jobs are added to and dispatched from the problem is if the jobs are not ented in order by date then I have to manually sort each time. This is a 24/7 process mostly accessed by mobile devices so sort is not an option.
-
Embedded form not redirecting after successful submission
Hi I have copy and pasted the embedded form code into our wordpress website and can successfully receive the entries from the form through the website to our smartsheets account. The problem is it hangs for the person/visitor entering the information in the web form and stays showing a message "Your submission is being…
-
Connector between Smartsheet and Google Docs
Hello, I need to connect Google Excel (Google Drive) to Smartsheet so that I can have updated data on Smartsheet. I need to know what is the best solution.
-
Report Builder
Hi Are there any written instructions I can refer to in order to create a smart sheet report that I can then build into a chart? I have tried to create a chart from a dashboard widget and I am getting an error telling me I can only use numeric data Is this correct? Thanks Tracey
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
-
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
