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,

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!