Cross sheet reference

Mily Oti

I have two sheets. In one, employees enter the time they spend on each task. This gets totaled to the column [Total Minutes]. On the second sheet I want to only show date and total minutes. I have no problem doing only one row but when I try to reference a complete column I get the error. This is my formula for one row only:

=IF({Translator Productivity Tool Range 1} = "LZ", {Translator Productivity Tool Range 2})

where range 1 is the employee and range 2 are the total minutes. This works fine but then when I try to reference the whole column it stops working. Is the If function the best one to use for this?

Any help would be really appreciated.

Thanks,

Paul Newcome

Once you enter a date, you can use a formula along the lines of...

=INDEX(COLLECT({Other Sheet Total Minutes Column}, {Other Sheet Date Column}, Date@row, {Other Sheet Name Column}, "LZ"), 1)