-
Blueprint Summary Sheet Cell Linking Not Keeping Column Type Property
There is a cell in our intake/project pipeline sheet that is a multi-select drop down. It links to a metadata sheet when a project is provisioned and remains a multi-select drop down. But when it's linked to the summary sheet, it's just a text column with all the checked options typed out. I changed the property of the…
-
Notification and capability to create report for all broken links (Cell Link References)
When links are broken on sheets, we want to be notified and to be able to create report on all sheets in Workspace, so we can fix all broken cell links ASAP. Each team has different schedule sheets and we use cell link from one schedule to another and we depend on the dates on the schedule. Currently there is no…
-
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…
