Need help with Countifs
Wrote this formula but its not working:
=COUNTIFS(Stage:Stage, "Active - Low. Probability", [R2 Offer Submitted Date]:[R2 Offer Submitted Date], >=[Bid Due Date]:[Bid Due Date])
Answers
-
Try using [Bid Due Date]@row instead of the whole column.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Could you us a helper column that does that logic for you.
Helper =IF([R2 Offer Submitted Date]@row >=[Bid Due Date]@row, "Yes", "No")
Then you can use =COUNTIFS(Stage:Stage, "Active - Low. Probability", Helper:Helper, "Yes")
-
The helper column worked, thanks.
R2 Submitted Date > BDD is the helper column: =IF([R2 Offer Submitted Date]@row > [Bid Due Date]@row, "Yes", "No")
This is working: =COUNTIFS(Stage:Stage, "Active - High Probability", [R2 Submitted Date > BDD]:[R2 Submitted Date > BDD], "Yes")
Now I need to add to the COUNTIFS if the [R2 Submitted Date] is blank and TODAY is >[Bid Due Date]
Thanks for your help
-
Why doesn't this work?
=COUNTIFS(Stage:Stage, "Active - High Probability", [R2 Submitted Date]@row, > [Bid Due Date]@row)
-
@Sean Maney That doesn't work because you [R2 Submitted Date]@row is not a range, you need to change it to [R2 Submitted Date]:[R2 Submitted Date].
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!