Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions