COUNTIF and...
=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7)
I have this working, however how do I add Only if the Status column from origin sheet is not complete?
I've tried variations around this...
=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)
Best Answer
-
Could you please share me as an admin on a sample copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hope you are fine, try to use "COUNTIFS" function it will help you to add another criteria
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
These did not work either
=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), [Status]:[Status], <>Complete)
=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)
-
Try the following
=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>"Complete")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Still no luck, even after adding " " around Complete
-
Could you please share me as an admin on a sample copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you for your help, I have created a copy of the workspace and shared it with you
-
In which sheet the formula, please open conversation in that sheet
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you @Bassam Khalil !!! You were a huge help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!