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.
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…
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…
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!
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.
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…
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…
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…
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)?
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?
It says I have 101 records to add. But I get this error message: error code: 1302; message:
I have a dynamic view that is shared to users outside our organization. I had the option to attached docs and also comment turned on. The issue I am running into is that all of the outside users can see the other users' comments and attachments. This is a problem because the attachments should only be viewed by our…
Can I make the Blueprint Summary sheet be my Intake sheet in order to combine in 1 document? Or does it have to be a separate document all together Intake & Summary? This would be instead of selecting summary fields to be linked back into the intake sheet.
Help shape the future of Smartsheet. Share your ideas and feature requests.