-
Smartsheet data used
Hi, we are getting to use more and more data smartsheet and i would like to know how much data I am using to control the data storage rate. Do you know how we can get this information. Best regards
-
Disable notification on add Alternate email and Set primary email via API
Hello, We are adding Alternate emails and then setting Alternate email to Primary via API, on both changes users get non-actionable notification i.e. "Your Primary Smartsheet email address has been changed etc." Is there any way to disable these notification via API or temporarily disable all notifications for mass change?…
-
Bridge - Pull Multiple contacts from one sheet & update one cell with all?
I am trying to use Bridge to pull all the contacts (Supervisors) from a roster grid that match the department defined by my trigger and then put all of these contacts into one single cell on my project tracking grid. So far, I've been able to get the array and then extract the emails I would need but there's a couple…
-
C# API access to row attachments
Greetings, I have been able to use the Smartsheet C# API to access sheet and cell data without issues. I added an attachment to a row and attempted to get information about it via the API: // Load the entire sheet Sheet sheet = smartsheet.SheetResources.GetSheet(selectedSheetID, null, null, null, null, null, null, null);…
-
QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
-
Smartsheet Bridge: Get Attachment
Hi, I refer you to Bridge: Smartsheet | Get Attachment article. The Get Attachment module returns useful information like: Attachment Type Created At Created By Email Name ID (of attachment) Mime type Name Parent ID Parent Type Size in Kb URL URL Expires in Milliseconds It returns the URL which allows users to download it.…
-
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
-
=Count IF 2 Number Range
I want to set up a countif that counts all of the numbers between 10 and 1000. Every time i set up a formula it only comes back with 1 instead of counting all of the times the cell has a number between 10 and 1000. =COUNTIFS({Formal Grid Quote}, >10, {Formal Grid Quote}, <1000)
-
Update the value of a contact
I am using the Smartsheet Python library, but this could also apply to the API. I am having trouble updating the Assigned To column, which I see is actually a column type of contact list. I have tried specifying a cell value and I get an error message saying "'Value is not supported for this column type. Use objectValue…
-
Errorcode: 1008, message: Unable to parse request.
Objective: Adding a row on smartsheet from ERP NetSuite (Uses javascript). The payload generated by NetSuite works perfectly via postman ! URL: https://api.smartsheet.com/2.0/sheets/xxxxxxxxxxxxxxxx/rows?accessApiLevel=0&allowPartialSuccess=false&overrideValidation=false Header:…