COUNTIF/IF Formula Help
Hello,
I'm trying to combine a COUNT IF and IF statement to another sheet. Here is my formula:
=COUNTIF(IF(AND([14 Apr 2024]1 >= {Project Intake Start Week}, [14 Apr 2024]1 <= {Project Intake End Week}), 1), >1)
Essentially, I have an IF statement that says if a number (referenced on the sheet) is between two numbers on a different sheet, count it.
Am i formatting this correctly?
Thank you!
Answers
-
You have a field called 14 Apr 2024?
I suggest you use cross-sheet formulas to bring your Project Intake dates into the first sheet and run the formula on the first sheet. If that works, then finish what you are doing here, because I do not understand why you are using COUNTIF to count the results of an IF.
-
Thanks for your reply @James Keuning ! the field you noted above is just a reference field I am using to reference which week number this column pertains to.
-
So maybe your field called "14 Apr 2024" should be called "Week Number"?
=COUNTIFS({Project Intake Start Week}, <[Week Number]@row, {Project Intake End Week}, >[Week Number]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!