Hi, I'm trying to create a Pivot Chart using the pivot app based on a number of sheets in a workspace. As it doesn't allow me to pivot on data from a workspace i have created a report, this works and i'm able to pivot on that data. The problem i have is when i pivot on the pivot sheet it has created a row called grand…
We have Control Center setup in our solution for managing IT Projects. Currently, we can manually provision a project through Control Center. How do we setup Control Center to automatically provision projects based on specific criteria?
Hi! Has anyone had experience with trying to connect SS multi select cells into Tableau so Tableau can read each item in the multi select cell? If there isn't a way to do it in Tableau I'm thinking I need to find a way to copy the row in SS down and have one item from the multi select cell in each row. So, if the multi…
is there a way to make a sheet wide change of links to another sheet? I have a pair of sheets I use with one being a data collection, and the second is used for creating visuals. I then use both sheets repeatedly for client work. -- just copy the sheets to a new area - rename and update the links respectively. A mass link…
I tried to follow the article to migrate power bi collection to power bi embedded (msdn article here). However, I got stuck very quickly. For example, in our app, we use these nuget packages (Microsoft.PowerBI.Api and powerbi.core), and these are some of our usages: client.Reports.GetReportsAsync(this.workspaceCollection,…
Does anyone know how to reduce the " - " between prefixes to just the dash itself ("-")?
We have built a training request and tracking system for our employees in Smartsheet. Badges are displayed when an employee completes recommended training milestones. Since I could not discover how to display an image based on formulas, I used the sports medal emoji (🏅) and formatted the font size to 36 pts in the sheet.…
We have a number of Datamesh Configs that are key to our operation. Today we are bottlenecked with only one user who can access these configs. I understand that we can transfer configs, but it simply moves the bottleneck. I am looking for a way to share existing Datamesh configs with a limited of number of users.
Hi An error occurred(picture attached) when I add the Smartsheet in channel files in Microsoft Team. I am the Smartsheet file owner and have allowed the Smartsheet application to be installed as it mentioned here. https://help.smartsheet.com/articles/2476201-integrate-smartsheet-with-microsoft-teams Any suggestion to fix…
Hi Is there a way to copy rows via Automations to EXCLUDE attachments? I know this is possible when manually copying to another sheet. Can you do this with Bridge or via the API? To exclude attachements when copying rows. Thanks you in advance. Regards, Pierre
Data exported from Smartsheet with individual contact columns is displayed in Power BI as email addresses. Multiple contact columns, on the other hand, are displayed in Power BI as user names. Is there a way or a setting to make this consistent? Imported into Power BI using the Smartsheet Connector: Thank you for your help!
I am trying to generate certificates of completion with document builder and include the date of conferral. No matter how I enter the date into a date field (my preference is "Friday, January 1, 2021" as the format), it always enters in the 1/1/21 format. Any ideas for getting document builder to fill it correctly?
Help shape the future of Smartsheet. Share your ideas and feature requests.