Countifs help

I have a sheet that has a column for the date and the second column that states "yes" or "no" beside the date as to if we have had an accident. This second column is called safety. I am trying to write a formula to count the number of days since the last time I input a "yes" in the safety column. Each time I write my formula I get #unparseable. This formula works in excel but not smartsheets. How can I change it to work?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!