-
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,…
-
Any tips on how to ask to be transferred to a new Account Manager?
Our account was transferred over to a new account manager, and all of the interactions so far have been quite frustrating. Has anyone been successful in requesting a transfer to a different AM? And if so, how did you go about it?
-
Unable to set-up Copy Rows Workflow, because of system generate columns
Hi, I wanted to create a workflow, that copies a data to other sheet (destination sheet) whenever a new row is added in source sheet. However, I do have some system generated columns like Added By, Date added, Updated By, Updated Date. The destination sheet was also formatted and designed as a same way as source sheet. I…
-
Workflow "Alert Someone" | Send to a contact in a cell
Hello Smartsheet Community, I am trying to create a workflow in Smartsheet using "Alert Someone" that will notify the Manager and Employee (two separate cells) that the specific task has been completed. Under "Alert someone" I choose "Send to contacts in a cell" however that cell is defaulted to "Created by"…. Questions:…
-
Having trouble sharing a sheet from an email notification
Hello, I receive an email when someone requests access to a sheet (since I am the owner) but when I click on "Share Sheet" within the email request, I am getting this error: I can go directly to the sheet and share with anyone just fine but I just can't do it from an email. Any ideas on why that doesn't work? Thanks for…
