-
Automate an "Active" field
Hi, I have a sheet wherby i have statuses, start and end dates, and also an Active field I would like the "active" field to populate whenever a status is either In Progress Review Sign Off And when the date is either Today, or in the past. I'd like the field to also clear, if none of the above is met. I have set up the…
-
Form not using logic despite being set up.
Hi, I have set up a form which will be filled out whenever a machine encounters a downtime period and have set up certain logic to show questions depending on the previous answer. For example answering 'Machine' with either "EMZ 3612" or "EMZ 3610" will show the 'EMZ Downtime Type' question and so on for other machines. I…
-
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…
