-
Python API Library Started Throwing Error
Hi all, I've been using the Python API to update a sheet on a nightly basis. It's been working fine until a couple days ago (not sure exactly when). Now when I call smartsheet.Sheets.delete_rows(sheet_id, list_of_row_ids), I get the following json response: {"response": {"statusCode": 400, "reason": "Bad Request",…
-
Created Date Issue
hi guys, as you guys can see, the Check-in Column is a Created Date column, the left date is the date I pulled from created date =Check-in@row, but apparently it shows the previous date if my employee scan under 6-7 a.m
-
Data Mesh filter
Hello, I am trying to use a combination of Data Shuttle and Data Mesh to 1. Keep a main data set up to date and 2. Based on the region the data belongs to, allow coworkers access to specific fields. My original idea is/was to use Data Shuttle to import an employee data file to a Base Sheet. That file would be updated once…
-
#INVALID REF appeared some hours after Data Mesh was run, do you know the cause?
A Data Mesh was set up and initially it worked correctly. However, after some hours suddenly the filed that are linked were changed to #INVALID REF. Nothing was changed in the configuration. Could you please explain why this happened? and how can it be fixed? Thank you,
-
Delete and modify configs in DataMesh
How does one modify an existing config? I can't find a way to modify and figured I would have to delete old config and create a new one. Problem with that is the old config won't delete. I click on trash can, say "Okay" when asked if I am sure , but the config is not deleted. Thanks.
-
Convert Image to Text in Cell
Is anyone familiar with any integrations that will convert the text from an image to fields in a sheet? Example: Use a form to take a picture of a business card, then the integration read that card and populate the name, email, etc. I know there are several tools out there that do this, but haven't seen one that integrates…
-
How to remove a specific object from an array
Using Delete from Array utility - I don't know which number the object I want to remove is. How do I identify which object to remove and then remove that object?
-
Populating a Smartsheet from an Oracle SQL DB
We use a smartsheet to track the progress of investigations on my site. The investigation ID, description, etc. are stored on an Oracle SQL DB and I'd like to autopopulate the smartsheet with the relevant fields. Is there a way to do this? I tried Power Automate but my organization does not currently support the Smartsheet…
-
How can restrict editing of certain columns in report shared in WorkApps
We have started using WorkApps and we have a report that contains several columns that need to be viewed by the users for context/info and others that are required for them to edit. How can I protect the info only columns without locking the columns in the underlying sheet? There is no way to lock columns in reports is…
-
Filter & Mapping Option not availabale in Data Shuttle
Hi, I am trying to setup a data shuttle to replace data in a sheet using the most recent SS attachment in another sheet. I have used Data Shuttle many times and not sure why this time it is not working. The columns in the SS match the columns in the excel attachment. When I get to the "filter" section of the configuration,…
