-
File Attachment to Row
Hi Team , I am trying to attach file to smartsheet row with the following details, https://api.smartsheet.com/2.0/sheets/{Sheet ID }/rows/{ Row ID }/attachments Header : Authorization:Bearer {ACCESS TOKEN} Content-Type:image/jpeg Content-Disposition:attachment; filename="C:\1.jpeg" ContentLength:64 Response I am getting…
-
Days Lapsed/Column Formula
How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it states it's not quite right to convert. Any suggestions?
-
Remove User API
Hello, I am attempting to remove a user and transfer their files to another user. Although the API documentation is clear, I am not getting the desired results. User gets deleted, but the sheets never get transferred: const options = { id: personToDelete.id, transferSheets: true, transferTo: userToTransferTo.id, }…
-
Sharing a sheet | specific columns for access
We are using the API feature and have shared a sheet with one of our vendors. They have asked if I can share the sheet that has been created with more members of their team, but they only want the new members to be able to access and update 2 of the columns on the sheet. Is it possible to share the entire sheet with people…
-
Custom Development Possible?
Is it possible to have a developer build a custom button in smartsheets that can for example pull data from it ..into a document.. Is smartsheets open to being developed on? I have the business package.
-
Is it possible to populate fields in Smartsheet from a 3rd Party application?
I've got a situation where we'd like to pull in some real-time data from our ERP system into a Smartsheet where we are doing some further tracking as things progress from month to month. From some light research, it seems as though an API could work for us, but I'm not too familiar with that and what our options might be…
-
Notification with Attachments
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps/software to automate that process? I have looked into…
-
Python SDK - projectSettings - nonWorkingDays
So me and the Python SDK is having a bit of a disagreement about updating projectSettings of a sheet and the SDK just gives me an error (the audacity!). Reading the API docs (https://smartsheet-platform.github.io/api-docs/?python#projectsettings-object) my interpretation is this: nonWorkingDays: "...The format for the…
-
why does "ss_client.models.ContainerDestination({" cause an error?
import json import os import requests from datetime import date import warnings from SSToken import MyToken #MyToken from simple_smartsheet import smartsheet from simple_smartsheet.models import Sheet, Column, Row, Cell, ColumnType MyShtIDNo = xxx folderID = xxx new_sheet_name = xxx ss_client =…
-
Smartsheet API Delete Row Function Error
Hi, When I run a code to delete multiple columns in a sheet >500. It run successfully once, the second try gave an error : Response: { status: 414 Request-URI Too Large content: { << text/html; charset=iso-8859-1 content type suppressed >> } JSONDecodeError: Expecting value: line 1 column 1 (char 0) The code below reads a…