-
API endpoint for summary information reports
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.
-
Card View - Conditional Formatting
Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry over to Card View...any ideas? See attachments Any help much appreciated, Jack
-
Show my the text file coming from Smartsheet Bridge
Hello, Please give me the json file coming from bridge output, the data reference is not helpful for me to create a json body to call this exact field:
-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…
-
Data Shuttle: Export to Multiple Smartsheets
Data Shuttle exports are limited to 20,000 rows of data in one Smartsheet. I would like to request to use one Data Shuttle to export into multiple Smartsheets, because we have more than 20,000 rows of data. Instead of creating multiple Data Shuttles, I would like to have one that can create multiple Smartsheets.
-
Calendar App Automations (API + SCC Integration)
Would like to utilize Calendar App within Control Center-generated Dashboards (embedded link), however, these need to be manually generated for each provisioned project. Please consider integrating Calendar App within SCC to allow for calendars to be generated and embedded automatically upon provisioning a new project. The…
-
How to create webhook for sheet as third party?
Hi Smartsheet Community, Our startup has fairly simple use case to update our backend systems when a third party Smartsheet document is updated that we have view access to. Based on our research, I understand that as a third party, the only way to receive webhook notification updates is by using a Smartsheet WorkApp which…
-
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
-
Bridge JavaScript doesn't have Normal JavaScript functions?
I am trying to convert a base64String to binary with the function "atob". However when I run the workflow I get "failed to execute extension module : atob is not defined:". I've had other issues with JavaScript functions as well that seem non existent. Is there something I am missing? @Danielle Wilson do you know? I…
-
Dynamic View update via Smartsheet API
Hello, Does anyone know if it's possible to update Dynamic Views programmatically via Smartsheet API? It's really frustrating that even such basic operation such as change of DV's source sheet requires creating a new DV from scratch. Thanks for any help!
