Formula Assistance


I am trying to identify how many times over the year a report was either received on time, late, or not at all. The reports are due to be received by the end of each month. The first attachment is the sheet which is being referenced. The report name being listed down the left side, and then identifying the date each month in which that months report was received. The second attachment is where I am trying to create the formula. Ultimately I would like to be able to display this information on a dashboard.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!