-
See summarized duration/ % for header tasks
I have created a master sheet that links all my project gantt charts. Unfortunately I cannot see the summerized totals - is this available as an automatic function? I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
-
#BLOCKED
Im trying to link some cells between sheets and keep getting this error. Can someone explain what it means? Cell shows up at #BLOCKED. Thanks, M
-
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…
