-
Data Mesh Config Not Updating When New Fields Added from Source Report
Hi -- I set up a data mesh initially with 6 fields from the source report. Then I decided to edit the config and add more fields to bring it, but it won't let me add them to the target sheet because they don't appear in that dropdown.
-
Is there any way to get good data from multi-select columns/cells in Pivot?
I've been working to use Pivot & Data Mesh to replace most, if not all, of my complex "summary sheets" where I have tons of cross-referencing formulas to pluck and calculate all the information I need from source sheets to trend KPIs. I love that pivot tables are dynamic, and update at my chosen cadence. For example, it…
-
Look-up Field and Database-Like Display
Does anybody know if it's possible, and if so which add on products you need, to create a front facing user site that has a place to basically input or select a value, and then view data dynamically being pulled from a source sheet for just that value? The use case is that we have a lot of properties, so wanting to create…
-
Is it Possible to Duplicate Row and it's Sub Rows - Linking Data
Hello! I'm new to using SmartSheet, and I recently downloaded the Payroll Register Template. I'm curious if there's a way to duplicate a row along with all its sub-rows, and if so, could you provide guidance on how to achieve this?? Also wondering if there's a method to link it to a separate sheet where I've compiled a…
-
Dynamic View Trouble
A dynamic view I am sharing with an outside consultant is displaying a % symbol in all the cells in one of the columns. It is there if the cell has data or is blank. Anyone have any ideas?
-
Power BI refused to connect error
Hi, I am trying to embed a Power BI report into a dashboard. I get the error message : app.powerbi.com refused to connect. Any suggestions on how to fix this? Thanks, Melissa
-
Bridge: Move a row within a sheet
I am creating my first bridge workflow to simply move a row within a sheet when the STATUS name changes. My sheet has a STATUS column with "Active" and "Inactive" parent rows, then child rows below each. In the Bridge workflow, from Integration I selected "Smartsheet" and the trigger is "When Column Values Are Changed".…
-
How to specify string in HTTP Call
Hi, I am doing HTTP Call to search for sheets that match the specified sheetName. I have several sheets that were created by Smartsheet Control Center that contain the text "Master Schedule". Query URL (pass): https://api.smartsheet.com/2.0/search?scopes=sheetNames&query="Master" When I search for sheets containing the…
-
Pivot table only has 2 decimal places
I'm creating a pivot table using the Pivot App from a sheet (also tried from report with the same data, and neither resolves the issue), where the values are percentages that go out to 2 decimal places. (Ex. 95.25%) The pivot table is converting the values (whether I do sum or average) to a number and only two decimal…
-
Questions about Bridge from a potential newbie
We are considering upgrading to Advance, and I have questions about Bridge capabilities: Our project blueprint includes multiple reports that pull entries from master logs based on the job number. This means that our admins have to add the job number to every single new report filter when they set up a project. Can Bridge…
