Help with rollup sheet structure and formulas

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

We have contractors that we pay every 2 weeks. I created a form for them to upload invoice info into. I also created a report that pulls the individual invoice totals. What i want to create is a rollup sheet that will give me a total of that week's invoices for a given contractor. So for instance...Total invoiced amount for John Smith from June 24, 2019-July 5, 2019...

 

Screen Shot 2019-07-15 at 2.40.19 PM.png

Screen Shot 2019-07-15 at 2.40.35 PM.png

Screen Shot 2019-07-15 at 2.41.01 PM.png

Screen Shot 2019-07-15 at 2.41.19 PM.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!