-
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:…
-
Ticket Tracker Notifications
We would like to have Ticket Tracker send an email to the person who submitted the ticket to us, when that ticket has been "resolved". I do not want everyone to get the notice, only this one person. Has anyone been able to do this? I can set the Alerts but cannot narrow it down to just the one person. I can do a reminder,…
-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
Possible to export a filtered Smartsheet to Outlook?
Hi there, I am new to Smartsheet and am just learning all the features it has to offer. I was wondering if it is possible to export a fiiltered grid view Smartsheet into Outlook 2013. Currently, i am able to export the entire Smartsheet to Outlook, but I want it to be tailored to only include certain events/tasks. Is it…
-
API 2.0 UpdateRows - Partial Success
Hi Community guys! I am using version 2.0.2.0 of Smartsheet C# SDK (smartsheet-csharp-sdk.dll). When doing bulk updates via "UpdateRows" using the API in C#, is there a way to use the parameter allowPartialSuccess (true or false)? Tnx, Mike