Need Help with Formula Creation



I am creating a metrics sheet for dashboard data. I need to create a formula that is using a reference sheet across two columns. One column in the source sheet is a name, but the second column is time. I want to do a (if name equals, then sum time for the name) formula.

If I wanted to put the formula is my source data sheet it would be =SUMIF([Researcher]:[Researcher], "FN", [Time spent | .1=6 minutes, .5=30 minutes]:[Time spent | .1=6 minutes, .5=30 minutes]).

Thank you in advance for any help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!