Reference cell value on another sheet based on the column value
I'm trying to figure a way to add the value of Time Spent in one sheet and add it to another sheet based on the value of the Location and Date columns.
So if location is Auburn - A Street and is today's date add Time Spent to sheet 2 in column is A Street for today's date.
Hopefully that makes sense. I a bit new to this.
Help Article Resources
Check out the Formula Handbook template!