-
Source Cell Linking - Link/provide info as to exact source cell location
I understand that when a cell has a link displaying info from a source cell, you can hover over the destination cell and see what sheet the cell is getting its information from. However, I think it would be most helpful if you could see/link to the exact cell location of the destination location rather than just the…
-
Helper sheet no longer populating
We have a helper sheet that absorbs certain orders, entered by a form, to fill another sheet. It is no longer populating. The only thing I know has changed is that some column names on the main sheet had been altered in order to set up an automation for a totally different sheet. Nothing else appears to have changed. Would…
-
How can I link predecessors from one sheet to another?
A task in sheet A is required to be completed before a task in sheet B can be worked. Is there a good way to do this? Note: I also have a master sheet that is fed from the values in sheet A and B combined. I want to be sure the integrity of that link carries over into our master sheet. Thanks!
-
How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an…
-
SmartSheets as Project Tracker-Too many manual steps. There has to be a better way
Buckle up. This one's a longread. TLDR: Skip to steps 5, 8 and 9 on this list. I've been using SmartSheets over the past month or so to replace my project management / status trackers. I like the automations (mostly) and that it seems fairly easy to use. It seems like it has some problems that I find very surprising and…
-
warnings, when a reference, cell link or formula get corrupt
Hi, I was wondering if it is possible to get warnings, when a reference, cell link or formula get corrupt?
-
Bulk Cell Linking - Columns
Hello - I am trying to perform the following actions, which would happen in this order: Person Inputs Project Information into Intake Form, which gets added to our master report. Column Examples - Project Name - Project Address - Project City / State A New Project Folder would be Created for this Project, Which Needs the…
-
Finish Date Static vs Duration Static
Can the Finish date be static and have the start date and duration dynamic? Example: I have Task 1 and Task 2. Task 1 has a duration of 5 days and Task 2 has a duration of 10 days. Task 2 has a dependency on Task 1. But Task 2 has a due date that cannot change. If Task 1 goes over the 5 days by one day, I update the…
-
Formula/Function to pull new rows/updated rows to another sheet
Hi Everyone, We have a critical issues list that is maintained by another group, and I've created an end-to-end schedule that will determine whether or not we will have the issues "validated" by our Week 0 deadline. Since the source sheet is constantly being updated and new issues are added weekly, I want my sheet to be…
-
Does anyone know how can I link cells from various projects into one sheets in order to make a gantt
Does anyone know how can I link cells from various projects into one sheets in order to make a gantt
