Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
COUNTIFS with a date range and symbols
This is probably a no brainer for some of you with a lot more experience so I apologize ahead of time.
For argument's sake, I have 2 columns. Column 1 we'll call DATE, column 2 we'll call SYMBOL.
I'm looking to count the number of "GREEN" symbols that have a date greater than or equal to 1/1/2017. When I use the following formula, I do get a result but in reconciling what's automatically calculates vs. what I actually see, it's not coming out correctly.
=COUNTIFS([DATE]:[DATE], >="2017,01,01", SYMBOL:SYMBOL, ="Green")
Any idea why my numbers vs. a visual look don't reconcile?
Thanks.
Comments
-
Adam,
No apology necessary. Try this
=COUNTIFS(Date:Date, >DATE(2017, 1, 1), SYMBOL:SYMBOL, "Green")
Hope this helps.
Craig -
Thanks Craig!
That seemed to take care of my problem.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives