-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…
-
Checking for duplicates between two different sheets
We are setting up a raffle where we will send out a form for someone to completed to enter the raffle. Once submitted we will take the (Full Name) column and randomly select a winner. We do have a few things on this sheet, we check to make sure there are no duplicates on the sheet, and once a winner is selected and checked…
-
I have Editor - Can Share permission on workspace but unable to edit the sheets inside it.
Hi We have a workspace on which I have Editor - Can Share permissions (screen shot 1 attached) but when I am going inside that workspace and open any of the sheet inside it and try to edit any cell I am unable to do so. Upon checking the sheet properties I noticed that I have commenter permissions (screen shot 2). My admin…
-
Free members are not able to edit the sheet in Business plan
Hello, We recently upgraded to the Business Plan with three paid members. However, we have noticed that unpaid members within our organization are currently unable to edit sheets or cells. Could you please advise how we can enable this functionality? We have multiple collaborators with different roles, including Viewers,…
-
Exporting Completed Forms
I have created Smartsheet forms for clients. I want to send them their completed form in a readable format annually, to double-check the information they have provided is up to date. The only way I can think to do this is to filter the intake sheet for the client I want, then export to excel. However, this is not a…
-
Merged: Sharing per folder
This discussion has been merged.
-
Identifying Sheet/Report Dependencies Across a Workspace
Hello, Is there a way to identify the dependencies of a sheet or report across a workspace? Specifically, I’d like to see which reports rely on a given sheet and whether those reports feed into dashboards. I’m not referring to usage metrics such as views, but rather how assets are interconnected. Thank you!
-
Multi selection form into single rows
Hi all, I have a form that allows multiple selections. Once the form is submitted I need the each selection to be added as a new row. I have several issues: -Selection list extensive (50+) therefore cannot be written as separated columns as suggested earlier. -Users will have a hard time to submit a form for each item and…
-
Taking Cells and then making a note with them
I am very new to Smartsheet and have been looking through all the comments but have not found what I am looking for In Google Sheets I use a Concatenate formula , that takes what I fill into the cell, I have about 10 different cells that it combines into the note cell, and then it make a note in cell AA for me and I can…
-
Form automation - API
I'm looking to develop a solution for copying forms from one sheet to another, based on matching fields in the forms. I am having difficulty, however in getting forms to appear as an attribute or an associated object to a sheet. What is the correct way to use the API for listing/discovering the forms associated with a…