-
Pivot Table using Sheet Summary Report
Hello, I need to create a Pivot using a Sheet summary report as the only source file. When I go to the pivot builder I do select my report as a source, but once I move to "Assign Columns" I am not able to select any row / column / Value to populate the Pivot: if i click on "Add Field" it always shows "Empty" (which is not…
-
Pricing
Why is it so difficult to get pricing from Smart Sheets? I have had 4 different scheduled telephone calls "to discuss my needs and processes to find the right solutions for my business" only to be asked at the end of a 30 min conversation when we can schedule our next call? I JUST WANT A PRICE!!!
-
Mobile App - Help with viewing public dashboards and favoriting forms
I've created a dashboard with several links to Smartsheet forms we use. I've published the dashboard and shared the published link. All of our employees have the Smartsheet app on their work phones. When they click on the published link to this dashboard though, it opens it up in their mobile browser, rather than the app.…
-
Data Mesh - Total Rows Not Matched, can I delete them?
I have just started using data mesh and I have the following issue I can't find a way to solve. If in my source sheet the Lookup Value cell of a row is edited, for example because there was a spelling mistake, when the data mesh run, it will create a new row in the target sheet, but the "old" row with the previous cell…
-
Pivot updates and charts in a dashboard
I have a pivot sheet with all of the data formatted the way I need it but when it refreshes it pulls columns back in that are not needed which impacts a chart within my dashboard. Any suggestions? Thank you.
-
Limiting Values Visible in Form/Dynamic View Fields?
Given a column that uses a series of predefined dropdown values, is it possible to specify which of these may be selected from a Form or from a field within a Dynamic View? I don't want to present all options to users.
-
Data Uploader connection...
I'm having connection issues with data uploader i.e. if I create a data uploader workflow, and grant access to Smartsheet to a Box or Onedrive folder today, the smartsheets seems to forget the access next day... it is not possible to manually edit the workflow everyday and fix the access issue for smartsheet everyday...…
-
Using Data uploader and Hierarchical sheets
I have a project schedule sheet, within it i have parent/child rows outlining each workstream (parent) and associated tasks (Child rows). There may be up to 10 parent rows and up to 20 child rows per parent. I am looking to use the data uploader to bring in detail to the child rows, for the most part our resource planning…
-
Removing Dynamic Report
Our two blueprints had dynamic report turned on until about two months ago when we turned it off when updating both blueprints. As I provision projects, some projects have an alert icon in the Control Center Project list with this message when you select the orange triangular icon even though they were provisioned long…
-
Creating a folder in Sharepoint via Power Automate
Good afternoon, I've been working on automating processes in our work order management, and seem to be running into complications when trying to create new folders in a sharepoint site when a new row is added to a sheet. How could I create a new folder in Sharepoint, with the name matching a certain column within the sheet…
