countifs with beetween dates
Hello,
I don't know what I am doing wrong here. I would like to count the lines that are between 2 dates, that have the name JO and the state of the line is DEMANDE DE PRIX. It's all in french sorry for that hope someone could help me resolve this. Thanks in advance ;)
=COUNTIFS({Suivis de recommandation Plage 1} >= [DATE METRIC]2; {Suivis de recommandation Plage 1} <= [DATE METRIC]3; {suivis de recommandation Plage 8}; =ESTIMATEUR@row; {Suivis de recommandation Plage 6}; "JO")
Best Answer
-
You are missing the semi-colon between the range and criteria for the first two range/criteria sets.
Answers
-
You are missing the semi-colon between the range and criteria for the first two range/criteria sets.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!