The dollar sign isn't showing up on my time tracking form

I download a time tracking form from smartsheet, but however I have 2 issues.

  1. The table for some reason does not have the dollar sign attributed even though i'm using this formula =VLOOKUP(Activity1, $[Task Name]$5:$Activity$10, 2, false) * Hours1
  2. I would like for each form entry to start below the previous entry instead of on top. What happens is that when an entry is made it goes above thereby making it difficult to maintain the formular.

I have attached an image, the test entry is the new entry while the other entries in the red box is the entry that came with the template which is what I'll like mine to look like.

Thank you


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!