-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
-
Error Message "Error: this link is invalid"
When linking from Sheet1 to a cell in Sheet2 I am recieving the Message "Error: this link is invalid". What is causing this? The dates in Sheet2 are driven by Sheet1, BUT there are no dependencies that set up a circular reference. I am wanting to bring back start date/duration for information only. We have been having some…
-
Impact analysis/Traceability?
I'm wondering how one would address this for managing changes to projects? For instance, in tools I've used in the past, I can answer the question "for the tasks/requirements that are at risk/due soon what would be impacted if it weren't completed?" and or "If I change this item, what is the ripple effect to my other…
-
Allowing users to only add a row to a sheet and view only those rows
New to Smartsheet and hoping this may be a simple question.... I want to be able to create a sheet that anyone in my company can access, but with the following permission groups: 1. Admin (full access) 2.Edit rights (limited to specific users, columns and rows) 3. View rights (limited to specific users, columns and rows)…
-
Insert Row: Automatically Links Cells
I am trying to figure out a way to best organize my project tracking... For example, my company has four big projects coming up, let's call them projects A-D. We have organized our sheets by project, and then created various sections within the sheet for each team working on the project, with sub-sections for task…
-
See summarized duration/ % for header tasks
I have created a master sheet that links all my project gantt charts. Unfortunately I cannot see the summerized totals - is this available as an automatic function? I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
-
#BLOCKED
Im trying to link some cells between sheets and keep getting this error. Can someone explain what it means? Cell shows up at #BLOCKED. Thanks, M
-
Bulk Document Attahcment
Does anyone know of a way to attached documents to a Smartsheet programatically? I have files that are named with a tag that is also unique to a specific row in my sheet (thousands, so manual attachment is out of the question). I would like to be able to periodically attach documents based on this tag as my sheet grows and…
-
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…