Monthly Calculation

I need to calculate monthly expenses but I've managed to stump myself on the formula/function. Here is my use case: I've got individual line items by user, but I want to sum their monthly expense by month. I have a range the individuals are contracted with us...say from 7/1/2022 to 5/31/23. How could I write the formula to look at that date range and pull out a specific month AND calculate the spend (if the hourly rate is known)?

Thank you in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!