-
Cell linking from Project to Project
Hello, when linking a cell from one project to another, is there anyway to have a lag - negative, for the task to start before then end of the linked cell or positive to have a delay. Also, while I'm posting can a task be linked to a task from another project but also have a dependancy from a task in the same project?
-
Looking for some suggestions or Ideas
We have been using Smartsheet for a few months now and want to enhance what we do. We run our customer projects on Smartsheet (all working fine). We would like to create a Change Control Web Form, however we want to pick up the Customer Name from one place, the project from another and the CCF details would be manually…
-
Can I link TO another sheet instead of linking FROM?
I need to link my issue log rows to a master issues log in a different workspace in SmartSheet. However, my boss does not want anybody to make changes in his worksheet unless those changes are done by linking our issue rows to it. The only thing I have been able to do is go into his master issue sheet and link to mine. Can…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Macro like functionality
Is there any method planned that would enable a change to trigger other changes. For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % complete column to 100 (and vice versa).
-
How to reference 100's of items with corresponding triggers to designate an end date.
Hi - Our agency has a formal record retention policy that lists over 100 types of records that we store or have digitized in-house. Question to answer/example: If the documents for Site A fall under Record category 1, they should be destroyed on 1/1/11, which is 100 days following the trigger date. I was able to create the…
-
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…
