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.
- 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
- 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
-
#2 in the Form Options you can edit "Location of New Entries" to Bottom of the sheet.
-
-
Thanks a lot @Ella and @Paul Newcome This was really helpful @Ella
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!