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

Chichi

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

Screen Shot 2020-01-31 at 12.31.33 AM.png

Ella

#2 in the Form Options you can edit "Location of New Entries" to Bottom of the sheet.

Paul Newcome

For number 1: You can format the column as currency.

For number 2: @Ella is correct.

Chichi

Thanks a lot @Ella and @Paul Newcome This was really helpful @Ella

Paul Newcome

Happy to help! 👍️