-
F4 funtion in excel
Could someone tell me what the equivalent in smartsheet is for the F4 funtion in excel that fixes the cells within a formula?
-
virtual parent to create high level view
I have a smartsheet like that. The question is, can I set line #4 as virtual parent of line #16, 17, 19, 20, so that on the start/end date and complete (%), it can reflect as a parent? Thanks, David
-
Summarizing Data using CountIF
I have created a Status Tracking sheet with multiple records. Each record represents a summarized view into a detailed task template. Each record also has a Status field, which we use to describe the phase of the project that we are in (there are four phases). I have used Countif to count the number of records in a given…
-
Avoiding double entry in multiple sheets.
I currently use Smartsheet for one purpose and still use Excel spreadsheets for another purpose. I have however hit a problem and wonder if anyone can help and provide a solution. Currently I have a sales spreadsheet for each employee. Each sheet contains a range of data. The range is the same on every spreadsheet and it…
-
Hyperlinking to templates
We have Project Tracking sheets with great detail, and we have project log sheets with a web form that saleman can fill out on their smart phones then submit and it populates into the Project Log sheet. I would like to link our project tracking sheet (template) to the new projects as they populate from the webform. Can you…
-
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, ~…