Countifs with an IF statement and dates
Hi, I have two dates in my sheet - a final filing date and an extended final filing date - I am trying to identify the number of advertisements that are closed (for clean ads)- I can count with this countifs statement the FFD but don't know how to factor in the extended final filing date when that field contains a date (is., is not blank).
=COUNTIFS([CLEAN POSITION]:[CLEAN POSITION], 1, [FINAL FILING DATE]:[FINAL FILING DATE], <TODAY(-1), [APPLICANT/CANDIDATE NAME]:[APPLICANT/CANDIDATE NAME], "ADVERTISEMENT")
Any help would be greatly appreciated!
Thank you all!
Answers
-
Hope you are fine, Could you please share a screen shot of your sheet after removing any sensitive data.
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"
-
sorry, I am unable to upload a picture for some reason with this tool - here's the columns
Final Filing Date Extended Final Filing Date Clean (check box)
2/26/21 3/5/21 Checked
Looking to count the rows that have Clean checked and a blank EXT FFD would count only the FFD; if there is a EXT FFD it would count the EXT FFD
-
sorry, I am unable to upload a picture for some reason with this tool - here's the columns
Final Filing Date Extended Final Filing Date Clean (check box)
2/26/21 3/5/21 Checked
Looking to count the rows that have Clean checked and a blank EXT FFD would count only the FFD; if there is a EXT FFD it would count the EXT FFD
-
Please send to my Email
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"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 217 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!