Thane Knutson’s Profile

Community member since December 2015

points
45

3

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

6

This did not seem to be covered and I'm hoping to find a formula without adding extra columns to my sheet.

 

Curently I have a secondary column separately maintained which lists months and I Sumif by this secondary "month" column.  I would like to Sumif based on date ranges.  Not simply from today()