WorkApps - Sheet filtering based on the Role
I have created a work app with multiple dashboards for each of my regions. They are all being fed by one list (Job List). I am looking for a way to do an automatic filter, so that the list is filtered depending on the role. For example Texas Region dashboard has the Job List sheet embedded, I want that sheet to auto filter…
Data Mesh Constant Updates of Cells Causing Thousands of Notifications (duplicates in source sheet)
Morning All, We are using the "Data Mesh" add on to mesh some of our data although we are having some issues. It seems that on one of our mesh's which we have selected to run immediately, it seems to be updating the cells constantly. This wouldn't be an issue except we have automations running off the target sheet that…
Script Error/Browser error connecting to Smartsheets from Power BI
Hello Experts, I'm trying to connect Power BI with Smartsheet and i run into script error "An error has occured in the script on this page. Do you continue running scripts on this page". I click yes and moves to next authentication screen. I try to login with my google account and i get below error - "This browser or app…
How to write a JQL query that pulls all tasks with an Epic that contains a particular phrase?
I am trying to write JQL query to use as a filter in the Smartsheet-Jira Connector that will find all tasks (all issue types) across multiple workspaces/Jira boards that contain the word "Exchange". So far the query: "Epic name" ~ exchange is the closest I have gotten, however it only pulls up epics and not the tasks…
Smartsheet sync with Google Sheets?
Was wondering if there is a way to sync or connect Google Sheets & Smartsheet's to where if I made changes to my google sheet it would make those changes in Smartsheet. I tried using the Sheet Director Add-on for google sheets and worked fairly well in terms of whenever a user adds a row in Google Sheets it would…
Why is Pivot not adding new columns?
I have several pivot tables that are linked to a sales database. The pivot columns based on the month. The issue I'm having is as the database grows and sales for the next month are added to the database the pivot table is not adding the new month column. How do I fix this?
External Content on WorkApps
I am unclear about what external content I can place in my WorkApps. Is it possible to include a SharePoint site URL? I am looking at a use case for a customer that--in addition to multiple dashboards--requires their Knowledge Database to be part of the portal. I realize that I could have a link on the dashboards, but…
Email when publishing a WorkApp
Does Smartsheet send users an email when a WorkApp is published? If so, does it send one each time changes to the app are published? Thanks!
Using a revised fillable PDF with Document Builder
If I revise a fillable PDF that was already mapped in Document Builder, do I have to "create" a new mapping, or is there a way to update the source sheet with the revised PDF?
How do I subscribe the enterprise package
Hi, I'm Derry from Indonesia, and me and my team also the owner, are working together to go paperless in all our daily operational data. We're a bird nest manufacturing company, with the size of 2000+ employees, and we only use 5% of machinery for all production process. Bird Nest is a handwork job, so human resources are…