Time-tracker formula



I have a time-tracker and have 2 problems:

  1. For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1
  2. When I remove the first entry which was a test, it messes up the calculation on the ones below the rate table. It gives me an #UNPARSEABLE message.

I have attached the image of the sheet



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!