thathotelguy
New Member
- Joined
- Jan 16, 2024
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
I am trying to create a tracking sheet for requested items/tasks, and I am looking to be able to input a;
Date of Request (lets say today if someone came in and asked for something and our goal is to have said task or item complete with 2 weeks {14 days} of the request so I want a separate cell with) >
Due Date (which would be 14 days from original date, then separate cell with) > Days Left (which would count down how many days left till the due date and have conditional formatting to change cell color depending on how many days are left)
I am not sure if stringing those different formulas together is possible because I believe I have seen them all used separately. Icing on the cake would be having a checkbox that could could be checked when the task is complete and grey everything out but honestly I would just be happy for having the formulas working together and I will hid rows once done haha
Any help is very much appreciated!
Date of Request (lets say today if someone came in and asked for something and our goal is to have said task or item complete with 2 weeks {14 days} of the request so I want a separate cell with) >
Due Date (which would be 14 days from original date, then separate cell with) > Days Left (which would count down how many days left till the due date and have conditional formatting to change cell color depending on how many days are left)
I am not sure if stringing those different formulas together is possible because I believe I have seen them all used separately. Icing on the cake would be having a checkbox that could could be checked when the task is complete and grey everything out but honestly I would just be happy for having the formulas working together and I will hid rows once done haha
Any help is very much appreciated!