-
Cross-project Date Dependencies
Hi, The Help page on Cell Linking says ( in the first paragraph ) that it's possible to do 'cross-project date dependencies.' Sounds like just what I need! But I can't figure out how. Does anyone know? I have several project with gantt sheets and I'd like to see how project dates are working together, or not. Thanks, ~…
-
cell linking
Is there anyway to cell link in templates? or Template to sheet? or just sheet to sheet? trying to keep annual running records for monthly reports?
-
Preparing the Process
Hi to everyone I would like share with others users my questions about peparing the sheet for organize the jobs of the company where I work to see what are you guys think about this subject. I have to organize and follow every job of the company. The company have a lot of jobs (many hundreds) and in each jobs have about 15…
-
Setting up incoming payments.
I see so much potential for this product in my small business and I'm really excited to try and find a solution for my issue. I have have a business with approximately 650 clients. Most of my clients are on a payment schedule (some weekly, some bi weekly and some monthly). I'm trying to figure out how to keep each clients…
-
Task completion updates
Hi, I have created a production schedule sheet which is viewed by the guys in the workshop. I'm trying to find the best way for them to give me updates on task completion. I dont want to give them editor access to the sheet because this them the ability to change the row details (resource). I have a %complete coulmn which…
-
Rollup report missing rows
Can't figure this one out. Hoping someone can help. I have 6 sheets for various projects we are working on. Each sheet has at least one level of heirarchy and some have up to 3 (parent/child/grandchild?). I have used cell linking to create an "amalgamation" sheet that lists all of the projects with their related…
-
Drop Down Lists
I am new to smart sheets and way behind my fellow community members level. I have a database spreadsheet for tracking new product development. Question: can you incorporate a drop down list into a smartsheet. Appreciate your advice and apologies for the simplicity of the question. Reagrds, Mark Quillinan
-
Absolute record references
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet, only within the same sheet, may work, too. I often want to refer to another record, but if the record number changes as…
-
How to merge the tasks from multiple sheets for a single user ?
Hi I am uding smartsheet to manage the opening of stores in several countries and I invite my internal staff with our franchisee's staff in a a sheet which is a Micro-Planing with 175 tasks to be executed for a neat store opening. Since we are working worldwide, we have several openings happening in the same timeframe. On…
-
Linking for resource tracking
Hi, I'm using rows linking when one task is needed for different projects. The Allocation % field is linked as well in such situation. The problem is that Smartsheet treats linked allocations as two different tasks and adds allocations, instead of reading Allocation % only from the master sheet. Do you have a solution how…
