- Can a one to many relationship be created in Smartsheets?
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?
- How to add new rows to category in smartsheet via form?
Hello, i need a form through which new products will be added. How to put them in the right category? For example, a checkbox where they offer to choose a category, and which one you choose, the line goes to that one.
- Global Update Workspace Logo and Colors
Hoping there will be a future ability to update all Smartsheet workspace logos and colors from an administrative perspective across the board. At the very least creating some type of API call to revert to Account Color Settings and Logo so someone doesn't have to manually click on every workspace (I personally have 232…
- Is there a package or repo to write whole Python pandas dataframes into Smartsheet?
I started writing some custom code using the Smartsheet python sdk to write pandas dataframes into smartsheet grids, but it gets complex pretty quickly with having to synchronize columns, efficiently running an upsert, and taking care of datatypes. So wanted to check if something like this exists already - seems like it…
- External API calls are blocked
Hi, External API calls are blocked in Company. How do we integrate API's using python. Thanks
- Report Names, Dashboard Titles and Widget Names with non-static strings
The name of reports, dashboards and widgets are limited to static strings, so the user will only know the name of the report and not what information is in the report. Example: The External Appeals Report title cannot be automatically updated to Q1 2022 External Appeals Report. Having automated strings based on the report,…
- How does giving query parameter "FilterId" filter the Get Sheet API response? I see no difference.
I am trying to give a particular filterId with a valid value of a manually created filter on a sheet, but the response however remains the same with and without this filter. On the UI of the sheet, filtration works exactly fine but I do not see the API response getting filtered out. Am I missing out on something? Do I need…
- Smartsheet Bridge/JavaScript functionality
Hi everyone! I'm trying to set up some automations through Smartsheet Bridge, but I'm running up against some possible limitations in the system and wanted to check with the community to see if there might be some workarounds. Does anyone know if it's possible to do one or both of the following: Access Smartsheet…
- Poll Folder for Changes
Microsoft Power Automate has a built-in function which allows you to automatically trigger a workflow whenever ANY sheet is updated in a folder (or across the entire account). Does anyone who what specific API call this function is making?
- Can I automate emailing attachments?
I have an approval automation set up but it does not send the actual attachments when "alerting someone." Is it possible to create an automation that emails the files that have been added to rows? If not, has anyone found a workaround? I've seen others post the same problem, but I haven't found a solution yet. Thanks!
