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.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!