How Do I Pull Data from Two Sheets to Summarize Output per Hour?
I'm working with two grid sheets that include various columns of information. Each has multiple rows of information. We have Smartsheet Pivot to help pull data together. Here is a simplified example:
Columns: Ticket#, Footage, Value, Date
Columns: Employee, Hours, Date
I'd like to total the footage for a particular date, total the hours for that same date, then get a footage/hour. How do I do that? I haven't used VLookup before, but thought that might be involved. Thanks in advance for the help.
Help Article Resources
Check out the Formula Handbook template!