bdchapin’s Profile

Hello,

I'm trying to calculate the average number of days but only for columns that meet the criteria.  I have a formula that is calculating the networkdays between two dates. This column is called Implementation Time (Days) - BD. I am now trying to average those days but only for when the Work Type

Is there a way for a master sheet to be automatically populated by project sheets? What I mean by this is that I have them linked currently but if I were to add a row to the project sheet would it add the new row into the master

Hello all.  Thank you for any help you can provide.

I have 5 fields containing averaged numbers.  I want to roll them all into 1 field to show the average for that specialty.  Anyone know of the right formula to use?  

In English, I have the average for 5 counties for primary care clinics and want

An unorthodox question but posting as I'm sure our company is not the only one who sometimes uses Excel as a Word document ...

We have an Excel document that we are importing to Smartsheet, and Excel allows the use of leading white-spaces in the cell so that overall the document reads better e.g.,

When I look at the Gantt chart on the sheets and in reports, there is a nice marker indicating 'today' which gives a great reference point. You can see this as a vertical dashed line in Capture1 below. 

When I create a dashboard using the same report I see the same data, however there is no vertical

Hi - 

I am running into a problem with finding the average of multiple rows based on the two previous columns.

I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other

For this particular use case, we only want to see the Gantt cart and don't care about the data in the left pane.


I want to be able to show a real time timeline display in the dashboard. But the widget not only displays the sheet view of the data, but it seems to favor it as well limiting my ability

I want to create an IF condition where if a cell contains a symbol on another sheet that equals "New" then populate that value otherwise, leave it blank.  I have this formula:

=IF({New Applicant(s) Range 1} = "New", {New Applicant(s) Range 2})

According to what I've read in the HELP, the False

Hello, 

I'm relatively new to Smartsheet and have inherited a complex network of sheets that reference other sheets. Unfortunately there are a lot of entries where come of the cells are properly linked but others are not and it wold be very helpful to write a report or come up with a filter that can

Hi everyone,

I'm needing to report on elapsed days for a few tasks. Anyone know how to do this?

Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet.

Any