Formula went in to invalid operation when updating date range

Options

Not sure what i accidently changed. please help i am not seeing my mistake.


=COUNTIFS({Behavior Based Safety Observation Range 1}, IFERROR((@cell), 0), >=DATE(2022, 1, 1), {Behavior Based Safety Observation Range 1}, IFERROR((@cell), 0), <=DATE(2022, 1, 31), {Behavior Based Safety Observation Range 3}, "approved")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!