Formula for date range

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to calculate the total amount of invoices, from a given contractor, within a given date range.

Im not sure how to write a formula to calculate within a specific date range.

I have the formula to calculate the total invoices for an individual. But not sure how to insert date range into the formula.

Here's where im at so far...

=SUMIFS({Contractor Invoice Upload Form Contract Inv Amount}, {Contractor Invoice Upload Form Contractor Name}, [Contractor Name]@row)

thanks for you help


Screen Shot 2019-07-16 at 8.13.09 AM.png

Screen Shot 2019-07-16 at 8.13.25 AM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!