Cross sheet reference
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,
Best Answer
-
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}, [email protected], {Other Sheet Name Column}, "LZ"), 1)
5
Answers
Are you able to provide screenshots of both sheets with sensitive/confidential data removed, blocked and/or replaced with "dummy data" as needed?
Thank you, I appreciate your help.
I am unable to see any detail in your screenshots. Could you please repost with sample data?
Sorry about that.
You said you want to pull the number and the date, but I don't see any dates in your target sheet. Just "156".
The date can always be entered manually, as long as the minutes get pulled in.
It works perfectly! Thank you so much for all of your patience and help.
Happy to help. 👍️