SUMIF within the last 30 days?

I am trying to sum the totals from another sheet that fall within the last 30 days. I've tried the "TODAY(-30) function but can't get it to work correctly. I'm assuming I need to add something to this formula that is currently giving me an all time total:

=SUMIF({Flight Activity Report Range 1}, MATCH(PILOT@row, {Flight Activity Report Range 2}, 0))


  • That appears to have worked. Thx!

  • Would you mind explaining how to rename the cross sheet references? Everytime I try and change from the generic "Range 1, Range 2" etc., The formula doesn't work anymore.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!