With the recent expansion of formulas to cross reference other sheets I would love to be able to split projects to other sheets. If I could pull the Primary column and the Start Date column via formula I could have secondary sheets that have their own unique information.
It says in the smartsheet help files that inserted blank rows should automatically fill formulas if the new row is between two contiguous formulas... For most of my sheet this is true. However, I have one very long formula that identifies a month based on the date and it seems to stump the
From a project sheet (with additional columns added) I'm trying to tally up the number of days by resource assigned to each quarter. So I want to specify a Q3 date range between 6/1/15 and 8/31/15, for example, as one of the SUMIFS criteria so that I only toal the number of days during that time