Auto Sum last 6 columns

Diane Martell

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?

Thanks!

Shaine Greenwood

Hi Diane,

Smartsheet may autofill this information for you if you add something to a row directly below/above the rows that contain your current formula. There are stipulations to this, see our help center article for more information: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting