-
Software solution using Smartsheet
Hello, My experience thus far with Smartsheet has been as a Systems Administrator for the last four years. Prior to my even learning Smartsheet, I had this idea for an app that would help to streamline a very specific business practice within the higher education industry. The thinking was that I needed to have someone…
-
Bridge Add Row containing Multi-Select Contact Cell
I'm trying to add a row, which contains a multi-select contact cell. The intention is to have this information flow into a column (separate sheet) containing the same configuration. Is this possible with Bridge? In a different workflow, I've successfully used the array function to update the drop-down list of a Contact…
-
Duplicating a sheet with document builder PDF
I have a template sheet that includes a fillable PDF. I can generate a document, download, attach, etc. Works fine. When I duplicate this smartsheet the fillable PDF is no longer available. I would need to go to document builder and upload the PDF again, match the fields, etc. Correct me if I'm wrong, but it seems like the…
-
Smartsheet API lastLogin returning no value for some users
Hello all, I made an API call towards the users endpoint to obtain the lastLogin data for our users. Most of the results came back as expected. However, there are some users (16.5% of total licensed users) that don't have the lastLogin attribute in the response. What is the reason for this?
-
API Conditional Formatting
Hi - It sure would be nice to have the ability to update conditional formatting via the API. I see a thread from 2016 - is this something that the dev team could look at? Many Thanks, Sean
-
Use data from one grid to fill master grid
Please consider this scenario: I'd like to update the data available in Grid 1 to a grid called Grid M. Considering that Grid M might have previous values, I'd like to overwrite them with Grid 1's data. I prefer overwriting instead of adding or copying rows because I want to use this Grid M as a master file that copies…
-
Smartsheet Webhook callback
Hi, When the smartsheet event callback is send to the url (server) it expects to receive a call back acknowledgment (status 200). If the subscriber fails to respond with a 200 status, depending on the response, Smartsheet may retry delivery up to 14 times. My question is how much time do we have to send back the call back…
-
How to add sheet owner via api
My integration is creating new sheets in Smartsheet. When a new sheet is created, by default the logged in user becomes the owner. But I need to update the owner based on the other system's item owner. When I add the owner email to the SheetObject it throws an error: {"The attribute(s) sheet.owner are not allowed for this…
-
Smartsheet to Power BI Power Automate
@Genevieve P. I Hope you are well I haven't connected with you for a while and i was wondering if i ask for your assistance. I have limited knowledge regarding this topic. I currently have a Smartsheet File that is updated regularly using a Smartsheet app I have created for time tracking. what I am trying to do if there…
-
Smartsheet API response is incomplete.
I am using this API - https://api.smartsheet.com/2.0/sheets/{SHEETid}?rowsModifiedSince=2023-01-15T00:00:00.000 , this is not returning all the rows that are modified since the given time. From the UI , I can apply the same filter and get desired rows.