freckles527
New Member
- Joined
- Apr 3, 2009
- Messages
- 6
I have the following formula and I'm trying to lock the results for that date. I'm trying to create an annual report and put it on auto-pilot.
The fields(columns) my teammates use when they update this task report are: date received | date due | Active/Complete | Date Completed.
The formula I have written right now is: =IFSUM('[Spreadsheet]Sheet'!$H$2:HE$77,"*Active*",('[Spreadsheet]Sheet'!$E$2:EE77))
It gives me the right count for the day, but I can't figure out how to capture if for that day and lock it in and then it recalculates at the start fo the next day in a different cell. This would be an annual report I can write so don't care if it takes me a bit to write it out and update the formula for each day.
The daily task spreadsheet can be updated if that helps me get the desired results. We want to track the active pipeline by day. I've been able to figure out how to capture my daily task they get done, but this spreadsheet had the name of the client and how many tasks in total we need to get done for them.
Thanks for all that reply. FYI - I don't know Visual Basic.
The fields(columns) my teammates use when they update this task report are: date received | date due | Active/Complete | Date Completed.
The formula I have written right now is: =IFSUM('[Spreadsheet]Sheet'!$H$2:HE$77,"*Active*",('[Spreadsheet]Sheet'!$E$2:EE77))
It gives me the right count for the day, but I can't figure out how to capture if for that day and lock it in and then it recalculates at the start fo the next day in a different cell. This would be an annual report I can write so don't care if it takes me a bit to write it out and update the formula for each day.
The daily task spreadsheet can be updated if that helps me get the desired results. We want to track the active pipeline by day. I've been able to figure out how to capture my daily task they get done, but this spreadsheet had the name of the client and how many tasks in total we need to get done for them.
Thanks for all that reply. FYI - I don't know Visual Basic.
