-
Master Sheets
Hi, I am trying to find a way to link my master sheet to new project sheets. My Master sheet already exists and lists all our premises, product in them and also locations of product. All we rollout new products - this all needs to be ammended in the master sheet. Is there a simple way to link this master sheet to any new…
-
Linking Sheets - Inbound link colors
We have a master project tracking sheet which links cells from several different project sheets. In general, when you link cells, a blue arrow will appear on the left side of the cell. I'm noticing that some of these cells have red arrows instead of blue. Does the change in color mean anything? ISSUE SOLVED Just figured…
-
link to another cell
It is possible to have two differents sheets, but once you update one of them in some cells the other sheet updates automatically????
-
How can i create a hiperlink for a cell in google sheets and link it to a cell in smartsheet?
Hello Everyone I am in the process of creating a budget sheet in smartsheet. I need to have a total monthly amounts transfer from google sheets to one cell in smartsheet. Also, when data is updated in google sheets also will update in smartsheets. Try to get a link for one cell but I can't find a way to do this. Any ideas?
-
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…
