PrettySophia
New Member
- Joined
- Nov 25, 2015
- Messages
- 3
Hello,
I was wondering how I would go about putting together 2 separate formulas for the case below:
I have table, within the table I have a column named " Status" and "Date of request".
Within the "Status" column, I have two filters: "Waiting on dealer" and "part is locked"
I would like to create a formula that captures all the entries within the filter "Waiting on dealer" and automatically shows if the entry exceeded exactly 7-12 days from the column "Date of request"
The same goes for the second formula : a formula that captures all the entries within the filter "Part is locked" and automatically shows if the entry exceeded exactly 12-30 days from the column "Date of request"
If this seems unclear or complicated, please let me know what information you need and I will get back to you ASAP!!
I a putting together a very important spreadsheet for work and I would really appreciate if anyone can help me on this issue. I have spent hours trying to figure it out
PLEASE HELP!!!
thank you all

I was wondering how I would go about putting together 2 separate formulas for the case below:
I have table, within the table I have a column named " Status" and "Date of request".
Within the "Status" column, I have two filters: "Waiting on dealer" and "part is locked"
I would like to create a formula that captures all the entries within the filter "Waiting on dealer" and automatically shows if the entry exceeded exactly 7-12 days from the column "Date of request"
The same goes for the second formula : a formula that captures all the entries within the filter "Part is locked" and automatically shows if the entry exceeded exactly 12-30 days from the column "Date of request"
If this seems unclear or complicated, please let me know what information you need and I will get back to you ASAP!!
I a putting together a very important spreadsheet for work and I would really appreciate if anyone can help me on this issue. I have spent hours trying to figure it out

PLEASE HELP!!!
thank you all

