-
Dynamic View not working
Hello, I have a full license to Smartsheet and am the admin to the sheets I am looking at. I am trying to use a dynamic view, and it is opening, but there is not tab for me to use to create a view. What could the issue be?
-
Auto Sheet Creation
I am not sure the right thread to ask this question, I saw a thread about this some time ago, and I was curious has there been an update to the software that will allow for automation to create new sheets given specific criteria?
-
Sheet or Folder sharing without sharing workspace
Hi, I have a folder of sheets, which I need to share with a group of people where some have Smartsheet account and some doesn't. I want them to have "edit and cannot share" access to the sheet and also people out of the organization should NOT be able to access the sheet. What is the best possible way of sharing?
-
Grant access to 1 specific folder in a Workspace
Hello, we have a shared workspace. Is it possible to only give people access to 1 folder and that the rest is hidden?
-
How is % complete calculated?
I built one of our first project plans yesterday after getting a working template set up. However, the %age complete on the project is very wrong. Here's how it's made up Initiation - 5 tasks in Initiation. All complete. Approximately 15 hours of effort. Definition - 20 tasks broken down into 5 subtasks. Its 95% complete.…
-
Only final tasks on critical path
Why are only the final tasks in my project appearing on the critical path. I have over 300 tasks in the project and have set up dependencies, i cant understand why only the last three are appearing in critical path view. This is the same when i filter by critical path. Can anyone help?
-
Highlighting discrepancy cells in duplicate rows
Hi, I have sheet with participants registration information for a study, and where the form is completed by participants. The sheet has columns like First Name, Last Name, Email address, Country, City, Institution etc. There are certain participants who are completing the registration more than once, and to identify the…
-
SUM Formula generating "0" by using SUM Function for four columns
I have sheet, which is capturing data, within this sheet I have four formula-based columns (Case 1: Score, Case 2: Score, Case 3: Score, Case 4: Score) which will produce either "1" or "0" based on the condition of the formula (and all these four columns type is text/number). I wanted to generate a total sum value of al…
-
Why am I not seeing "Save as New" on Folders?
I right click on the folder name in the left panel, but there is no "Save as New" option as described in the Help articles. I don't have > 100 items in the folder either. What am I doing wrong? This is all I get.
-
How can I merge two worksheets together?
If unable to merge (which is what I have read) is there a way to compare column headers in a way that would highlight similar headers or point out differences? If unable to merge, nor compare, what is the most efficient way to make one worksheet that contains the column headers from two? I thought of exporting to excel,…