Formula to determine how many times something occurred in a row

Hi everyone,

For my business I have multiple trucks, and every morning we record the statuses of the trucks before they start driving. I have multiple columns, each one being the different trucks. In the rows for those trucks I record the statuses for the different trucks. So I have "Available","Breakdown" etc.

I'm trying to write a formula in which I see how many days in a row that Truck has had that status for from the most recent date. Would someone please be able to assist with this?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!