How do I create a cross-sheet formula for a sum $ total within a date range

edited 12/09/19 in Formulas and Functions

I'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as "1/30/19" for January 30, 2019. 

For example, in the sheet in which I'm attempting to place this formula, the first column contains customer names with none repeating. The second column is "total spend in 2019", where I'm attempting to use a formula to calculate this based on the transaction summary sheet, the sheet I'm trying to reference in the formula. Any help is appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!