Trouble with a COUNTIFS formula
I can't figure out how to make a COUNTIFS formula to work.
This works: =COUNTIFS({Target Launch Date}, <=TODAY(30), {Target Launch Date}, >TODAY(0))
This works: =COUNTIFS({Header}, <>1)
This doesn't work: =COUNTIFS({Target Launch Date}, <=TODAY(30), {Target Launch Date}, >TODAY(0), {Header} <> 1)
----------
I'm getting an #INCORRECT ARGUMENT SET error
Target Launch Date = Date field
Header = Checkbox
(*I used Bold and Italicize to show components of the 2 formulas combined. I would have used colors, but not available.)
Best Answer
-
I reset the Target Launch Date reference, and it started working.
Here's the steps I took: Hover over the formula, click 'Edit Reference' and re-select the same column you (thought you) were referencing already...
Hope this helps someone
Answers
-
I reset the Target Launch Date reference, and it started working.
Here's the steps I took: Hover over the formula, click 'Edit Reference' and re-select the same column you (thought you) were referencing already...
Hope this helps someone
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!