Thane Knutson’s Profile

Community member since December 2015



I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list.  It is spread across several years of spreadsheets making a larger conversion to a list time consuming. 

I have a request for Report Filters to have


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


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()