-
I need a solution/work around Data Mesh not pulling in Columns with Column formulas
Here is my scenario: I have my source sheet that collects data from a form. The form is set up dynamically to allow the user to select different options from a multi-select drop down list based on which team they would like to work with. This creates multiple columns, so to aggregate all of the options selected in to (1)…
-
Using Control Center to update drop down lists on a regular basis
Does anyone have the need to run a regular (say once a week or once a month) global update to maintain dropdown lists on sheets that are in your template and pushed out to projects? What I am talking about is the ability to have a "Recurring Global Update" set on a schedule to run each week, or month, that will update the…
-
PowerBI and Regions
Hi I went to login to Smartsheet for PowerBI and just like with other integrations, regions does not seem to be available. I might be missing something but the login does not give options for EU. Is there a reason why EU is not being supported as well? there are really good reasons for my clients to be on servers in…
-
How do I switch the below on in workflow?
I just can't remember how to get the replace existing values button on. I have it in other sheets, but ... Thanks Jo
-
Dashboard Embeded on SharePoint issue with resizing
Issue Description: When embedding smartsheet dashboards into Sharepoint sites, the “resize to fit the page” stopped working. We have many pages, with multiple dashboards embedded, that have all worked fine, and have resized to show the full dashboard within the space on sharepoint. As of 12-6-23, that resizing has stopped…
-
Bridge - SharePoint Integration Error: When field from the source sheet is blank
Hello, I have created a bridge integration which pushes various fields housed in a Smartsheet to a SharePoint list. I have successfully done this on multiple format types, including text, numbers, checkboxes, etc. I have incorporated errors in my Bridge workflow when pushing various Smartsheet columns that are blank. The…
-
Control Center Assets Clarification
We are currently building an extensive template/toolkit to be used in a Control Center multi-tier program and I am concerned with the asset limitation of 90 assets (see picture). My question is, does CC count folders and subfolders as an "asset" or just sheets, reports, and dashboards?
-
Smartsheet Pivot is no longer replacing all the information on the target sheet
I created a Smartsheet Pivot that was working as expected for a couple months, and suddenly this week it stopped replacing all the information on the target grid like it used to (and needs to for my purposes). This pivot is meant to generate a fresh dataset in the target grid at an hourly cadence, that is then filtered…
-
Offload Date Format
Hi, I'm using Data Shuttle to Offload a title and some dates and it is coming through with a really wonky format. Excel isn't able to auto convert this to a regular date and I tried using INT to try to make it into and integer but it returns a #VALUE! error because of the format. Is there any solution to this? This seems…
-
Is there a way in DynamicView to allow people to be editors of specific rows?
Is there a way in DynamicView to allow people to be editors of specific rows while being able to view all of the other rows at the same time?
