-
Getting last login information via API call
I am hitting the users endpoint(https://api.smartsheet.com/2.0/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any user. I can see this information when I export the csv of the users from the admin…
-
APPSHEET API WEBHOOK
Dear all, I hope this message finds you well. Although I don't have any coding experience, I have been using AppSheet for some time now. Recently, I have been working on integrating Smartsheet into our project management processes, specifically for tracking our projects as a building company. One of our requirements is to…
-
Using API to update contactlist dropdown
Hello I have a script that pulls names and emails from a report and updates the dropdowns for a contact list column. I have 4 of these columns on the sheet all with the same conditional formatting. For some reason when I run the script it works fine on 3 of the columns but the last one "WorkOwner" I get a bad request…
-
How do I get the Metadata from the Smartsheet?
Hello All, I am able to get the Row and Column from the smartsheet JSON response but in it there are no metadata. I used things like: params = {'include': 'objectValue,objectProperties,format,formula,columnType,options'} and passed it with the request. But I still do not get any metadata. Specifically, I am trying to get…
-
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
-
Merged: Option for two windows open for the Smartsheet Desktop App
This discussion has been merged.
-
Sharepoint embedded into smartsheet error refuses to connect
Sharepoint hosts our powerBI content - we have embedded that link into our smartsheets dashboard via a web content widget. Everything was working prior to yesterday morning, now we are receiving an error companyname.sharepoint.com refuses to connect has anyoen received this error? and how do I resolve this? Sharepoint.com…
-
Enable Premium Apps on user accounts via API
Enabling Premium Applications on user accounts via API is currently not available. The "admin" api that runs the admin web page does have this capability, but the public API does not.
-
Uploading Attachments within RM Time & Expenses Tab
Customers would like to use RM for time and expense tracking. A lot of times, customers are required to submit invoices/receipts to support their expense submission requests. However, within RM their is no ability to do this. My idea is there should be a button within "Add Expenses" that allows for supporting document…
-
Error 5262: "Unable to create the requested cell link(s). The source data is no longer accessible."
Hi, I'm getting this error message when attempting to create a link from a cell in another sheet (through creating a cell, a row, and then update_rows method). Has anyone seen this error? I'm reading a discussion on another thread that this error is related to some issue with profile data (?), but I can create this link…
