-
Duplicate Values in column
I am having an issue with a sheet where we had changed some of the values in the dropdown of column properties, but because the old values were used previously, unless a user selects the dropdown, they can start typing and select the old value. It creates an issue when trying to analyze the data. even when we override the…
-
Webform hosted on another site
Hello I've created a webform that I've inserted as a iframe on a wordpress site, which works. But I wonder if its possible to create a form which uses your API to create a post on a sheet instead, which is hosted on another site, like my wordpress site?
-
Incident Tracker
Does anyone have a template or solution for tracking incidents related to IT infrastructure, applications, etc?
-
setting up my business correctly
I have a home building company and I am not clear as to the best use of workspaces, work sheets and folders. Can someone help or do I need to hire an IT person
-
ColumnId's return null
Hi, I' m trying to get column id values for a sheet but values return null. I' ve tried following methods. Token token = new Token(); token.AccessToken = MY_TOKEN; long sheetId = MY_SHEETID; long columnId; SmartsheetClient sc = new SmartsheetBuilder().SetAccessToken(token.AccessToken).Build(); //Method I Sheet sh =…
-
Alerts to non-shared resources
We are trying to implement an editorial calendar. Smartsheet works great for this in theory.. ie: we have the primary row as an calculation that shows us: "Client (Content Type) Title (Creator name)" - perfect. this is awesome. We have the due date as the calendar date. - Again.. perfect. HERE IS THE CHALLENGE We have…
-
Can Smartsheet integrate with AP software, like Lawson?
We need a solution to integrate with out accounting software.
-
Adding attachment via the API
Hey, I'm using the API to create a sheet and I want to attach a pdf to each row. It looks like I would need to first create the row, then get its rowId before I can add an attachment to it. is there a way to include the attachment as part part of the row creation? Basically, is the rowId mandatory, or is there a way around…
-
API write over a sheet
Hey, I want to feed my sight/report with a sheet refreshed once a day, however I'm not able to find a way to write over a sheet so that the sheetId remains the same. There are too many possible changes to use updateRows, as some of the rows could be removed and/or added as well as updated. Is there a way to write over…
-
Help to understand webhook callback JSON
API Webhooks sends Sheet column update callback JSON with multiple row and cell objects as marked updated. How do you find the correct rowID to get column values for the updated row? For example, I changed the status of one row column from A to B and received the following JSON from webhook callback: Body:…