-
Bulk Document Attahcment
Does anyone know of a way to attached documents to a Smartsheet programatically? I have files that are named with a tag that is also unique to a specific row in my sheet (thousands, so manual attachment is out of the question). I would like to be able to periodically attach documents based on this tag as my sheet grows and…
-
'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????