-
Moving rows and losing formulae links.
Hi there, I use smartsheet a lot to manage and track report issuing between multiple users. I regulary have problems when moving rows to enable organisation by priority and the cell links within the row change. I have to reapply the formulaes in certain cells which can be time consuming. has anyone else had this problem or…
-
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…
