Product questions?
Ask it here! The community's got your back.
Discussion List
Dynamic Views - Enterprise user
I am an enterprise user at UCSF. Do I need to be a premium user to create Dynamic Views on sheets I own?
Bulk Update Premium App Permissions Issue
Trying to use the 'Bulk Update Premium App Permission' feature. We received the template, updated it and on the upload we get the below error message: ''To upload this list, make sure everyone in your file has a correctly typed email address' However we never changed any of the email addresses, simply amended True/False on…
Pivot Table using Sheet Summary Report #2
Can I use a summary report as a source for pivot table? I need to include different sheet names as columns and add the products for each one of them. I had a pivot using a summary report and it was working as of yesterday but now is not and I cannot recreate it!!! HELP!
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
Can I pre-populate a form with data from a sheet?
I am looking to create a form that will pull in current data tied to an ID from a sheet. I envision having the user enter the ID in the form and certain fields will pre-populate based on the entry. Is this possible, or is there an alternate solution?
Power automate insert row not working using dynamic Sheet Id
Hello - I am trying to use the Insert Row Power Automate Smartsheet connector and it works when the sheet ID is static/hardcoded; however, I need to be able to pass in the Sheet Id from prior step. When I change from static Sheet Id to dynamic, all of the sheet column fields go away. The problem I am having is formatting…
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…
Control center: include template(s) based on value in Intake Sheet
In control center is it possible to set up so that template(s) is included during project creation based on the value in the cell on intake sheet?
Why is the Dynamic view on evaluation mode not letting me share views?
Hello all, A member of my team has initiated the evaluation period for Dynamic View and yesterday it allowed him to share views. Today we are both getting the following message "You cannot update sharing because you are outside the view owner's organization" and is not letting us share the views with anyone. I'm the…
Using Document Generation to invoice monthy
We are trying to auto-generate monthly invoicing from a time tracking sheet. The sheet has multiple entries for the same project-daifferent dates. It also has multiple assignments within the same project. What is the best process so we do not generate a separate invoice for each line in the time tracker, but one invoice…
