-
Connect Xero Reconciled Bank Account Balance
Hi, I am completely new to Smartsheets and I have an issue with regards to integrations with other software. I basically want to connect the reconciled bank balance from Xero to a 12 month cash flow I am developing in Smartsheets. I am currently unsure which trigger via Zapier to pick and was wondering if anyone knew or…
-
Resource Management People Export - Automated?
For Resource Manager Users is there an easier/automated way to export People Data from RM? Currently the only option available it to "Export People List" which downloads a .csv file that has to be loaded manually into downstream/dependent systems.
-
Is it possible to pull an activity log that includes a cell history report with time stamps?
Hi there. I am relatively new to Smartsheet and have been enjoying all the tools that this platform offers, but I want to see if I can make it work even better for me. I am essentially a process manager that sends reports to various stake holders via Smartsheet status changes The stake holders are dependent on the…
-
Print Dynamic View
Print or export the Dynamic View in order to distribute it to students and faculty.
-
WorkApp Suggestions - Importing Users
Hello, I use WorkApps frequently, and I am trying to introduce it for use throughout our entire organization. An item I wish it included/expanded on: Allow importing of users into a role. Importing from an Excel file would be very useful. I have a client who has a large group of users in one location and wants to use…
-
Smartsheet - Azure DevOps integration
Hey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a row is updated in Smartsheet (and vice versa)? My goal is to be able to update fields in…
-
Creating a bug burndown dashboard in Smartsheet
Hello, We are currently using the SmartSheet + JIRA connector which allows us to export JIRA stories to SSheet and have bi-directional editing capabilities of both sources of data. This works great and allows team members (like our QA team) who do not have JIRA accounts to update their SSheet and the changes are…
-
Is there a way to get a clean xlsx export out of Smartsheet that matches the Data Shuttle file?
We use Data Shuttle to export data to OneDrive where Power BI picks it up. I have a need for users to able to replace that OneDrive file manually so they can force a Power BI refresh and ensure they have the latest data. Both the Export from the sheet and Export from report or Send as Attachment from report create an xlsx…
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.