Timetracker formula
Hello,
I have a timetracker and have 2 problems:
 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
 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
Thanks
Answers

Are you able to provide a screenshot that shows more of the sheet including your column names and row numbers?

Yes sure. Here it is

And I assume your formulas you want to actually use are in rows 12 down?
=VLOOKUP([Talent/Materials]@row, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours@row
Using the @row reference tells the formula to evaluate based on the data that is in the specified column in whichever row your data is on. It may be that the formulas in the lower rows have an incorrect row number.

Ok I see. Let me try that out. Thanks

It worked. Thank you

Happy to help! 👍️
Please don't forget to mark the most appropriate response as "helpful". That way others looking for a similar solution can know that one may be found here.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!