Sums and Cross Referencing on two sheets
I have created a sheet to track vacation (Vacation Requests Sheet). A form is submitted that includes Name, # Days Requested, Start and End dates. The Vacation Requests Sheet will then generate a PDF. I am trying to calculate the number of days off to date based on the employee # but need it to start at zero on the first submittal. Once that is complete, I have another sheet (Field Employees Sheet) that has their employee info, including how many days of vacation each is allotted and how many vacation days they've used. I need the vacation used to pull from the Days Off to Date column on the Vacation Requests Sheet. Let me know if you need more info.
Vacation Requests Sheet
Field Employees Sheet
Answers
-
Hello K.Nixon,
Can you provide more details? Is the [Days Off to Date] column a total of the [# Days Requested] column and the [Days Requested] column? Are these two columns duplicates? Why do you only have one [Start Date] and one [End Date]? What formula do you have in the [Remaining Days] column and the [Remaining Vacation Days] column? Can you write in pseudocode the expected formula for the [Days Off to Date] column? (e.g. [Days Off to Date] = [Days Requested] + [# Days Requested]
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!