-
Restrict Editing but Allow New (dyanmic view)
Hi, Is it possible to restrict editing of existing rows but allow submission of new rows? I tried locking the columns and rows but that did not work. TIA.
-
Linking multiple cells at once - from vertical in the source sheet to horizontal in the destination
Hello - I have a sheet that is a questionnaire with basic check boxes. The questions run vertically down a column, with the checkboxes in the adjacent column. I would like to link those cells, that exist vertically in the source, to a destination sheet, where each row is now a column. I can do this cell-by-cell. However, I…
-
SR1 Error Message
I recently added a couple of new profile data to my blueprint and provisioned a test project to verify it. The project was provisioned with a note "Summary Reporting: no template attached to reporting sheet (SR1)". I check the project folder and the cells are all linked correctly in the sheets but the project is not added…
-
How to select a different sheet to update a Pivot Table
Hi there, I still learning with pivot app. I want to update one pivot table selecting a different sheet, in other words, I need to change the data source. Is that possible?.. When trying to update, I see the option to select a sheet is disabled. Thanks in advance!
-
Dynamic View Logic not saving
I am trying to create conditional logic in dynamic view but when I do, the Save button is always greyed out. My Business Unit column is a dropdown single select column, because I know the logic needs to work off this type of column. I can't figure out what it doesn't like about my logic and why it won't let me save.
-
Why is Dynamic View only pulling through one set of drop downs for a specific column?
I am new to using Dynamic View. I have three sheets that I combined into a row report and then have been trying to create my view off of that report. I have a column named request type on all three sheets and each sheets has different drop down options for that request type column. When I go to do conditional formatting…
-
Excel Data Extract
Who has experience with Zapier (or another app) that will allow Excel data extract into an existing Smartsheet? Need more functionality than just whole rows. Too complex to accept creation of a new Smartsheet with each Excel data transfer. Data Uploader won't work. Would like to be able to extract individual Excel cells…
-
Clearing data from smartsheet before data uploader runs
I have a smartsheet that I am populating monthly with a job from data uploader. The smartsheet has several columns that are manually updated between uploads. For example, January the uploader will run and import data to overwrite existing data in Rows A-C in Columns 1,2,3. Column 4 will be manually updated sometime after…
-
Document Builder Automation with Forms
Can Document Builder be automated so that after a form is filled out the document is automatically created and sent to the person who filled out the form (or any other identified person)?
-
Using System Column in Dynamic View
I have created a dynamic view which references the system column MODIFIED. Unfortunately, the optics of that column are not optimal. See screenshot. Any suggestions how to get this to appear merely as a standard DATE value?
