-
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…
-
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?
