-
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
-
Advanced Cell Linking Capabilities?
When we list our monthly marketing promotions (what's new, what's on sale, what's exclusive) in our Marketing Master Plan, we link those cells to other sheets where it would be useful to have that data on hand (for copywriting, graphics design, email plan, etc). Only problem is that if something gets added at last minute…
-
Dashboard
I have developed a dashboard sheet that contains data from 3 different source sheets. Unfortunately, it requires me to manually input the data. Is there a way to use a formluain one sheet that relies on data from another sheet. I know this can be done in excel, but can't seem to find a solution with Smartsheet. I know I…
-
Is it possible to Auto-Fill dates?
Hello, I'm sorry if this question has been asked before, but I couldn't find anything through the search function... I have prepared a template for event management. We use the same structure for every one of these specific events that we do (the event date is announced, and then we work back from the date to establish…
-
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…
