-
Ordering Jira connector by rank
We want to be able to display in smartsheets our backlog by rank. Meaning we want it displayed in the order the product owner has arranged it in. We also need to use JQL to get the detail we need. Here is the query that works as expected in Jira: project = HU AND issuetype = Story AND resolution = Unresolved AND (Sprint =…
-
Column Names in Power Flow (Copy data from Smartsheet to Excel)
hi, i am trying to build this MS Power Flow to copy new data entries from Smarsheet to Excel and create new rows in Excel. but i cannot get it working, as i dont know what to put in these empty bars below column names (yellow highlights): I assumed it would be just exact column names in smartsheet, but it isnt, as when i…
-
Developing a row URL in tableau
I am connecting to smartsheet with Tableau to report on data entered into Smartsheet. The sheet owners would like to navigate to the row in Smartsheet from Tableau. Is there a way to generate a row URL from the fields in Tableau to generate a row URL for users? I am pulling in the sheet id and row id fields into Tableau,…
-
Taking and showing attendance for instructors in a class
I have a form that is used to take attendance for 6 weekly sessions. The form populates a contact list for each class and calculates each participants progress during the 6 weeks using a JOIN DISTINCT COLLECT Participant@row formula. There are 3 different cohorts of the same class going on at the same time. I have a sheet…
-
I am using the Data Uploader to update a list of Store Addresses, which is used as a link in another
The Data Uploader is working fine for the update of the Store Address Sheet; however, I have the Store Address Sheet linked to another sheet, which is not updating when the Store Address Sheet is updated. When I go to Manage References the Sheet Reference Manager is showing the Status as Broken. In addition, I noticed on…
-
Control Center- Global updates to Dashboards
When I make a global change to a dashboard it duplicates the dashboard in the folder, I am building 200 plus dashboards which must be updated centrally so cannot have duplications. Have a missed a step, appreciate any feedback asap!! Thanks
-
Automating updates from other systems, such as Oracle
Is there a way to set up a link or request to Oracle for example to run a report and upload updated information automatically? This question is for a co-worker, he is the one that currently has to pull data into Excel for everyone, so he would like to automate the process to keep from constantly dropping what he is doing…
-
Calendar App view
Hi community, Is there a way to put my events on a flat plain? Currently, it separates them in a kind of descending view, which makes the calendar really tall and difficult to look at (see attached). Any help is greatly appreciated!
-
Data Uploader Not Displaying Time from Import
Hello, I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and…
-
Bridge and Quickbooks
Can bridge be used to communicate with quickbooks? Specifically, can Bridge export purchase orders, and budget estimates to quickbooks?