Countif multiple criteria and date
I am trying to get a formula to do a COUNTIFS based on multiple criteria, but also that one of the date columns is greater then a specific date. The formula I'm currently using is:
=COUNTIFS({BDDM}, "=Amanda", {Appt}, "<>")
What is the best way for Smartsheet to read a date greater then, in a column titled Date.
Thanks in advance!
Comments
-
Hi Shauna,
I'd recommend looking at our Creating Formulas article, as this provides information on the syntax that Smartsheet is looking for with functions: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
A few things I noticed about your formula:
- Remove the equals sign for Amanda
- Remove the quotes around the <>
- You'll need to reference or create an actual date value to compare your second cross sheet range to
An example of a formula that works in Smartsheet:
=COUNTIFS({BDDM}, "Amanda", {Appt}, <> TODAY())
The above function will look for the word Amanda in the {BDDM} cross-sheet reference that you created. It will also look for any date values that aren't equal to the current date in the {Appt} cross-sheet reference that you created. Once both conditions are met, the item will be counted.
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!