Auto Sum last 6 columns

Diane Martell
Diane Martell ✭✭
edited 12/09/19 in Formulas and Functions

Hello ~

I'm calculating attendance and want to highlight inactive participants. Currently, I copy and paste  =COUNTIF([20 1/6/18]3:[25 02/10/18]3, "P") each week as a new column is added. Is there a formula that will auto add new entires and also limit to the last six columns?


Screen Shot 2018-02-11 at 10.34.50 AM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!