Sheet Summary cell reference changing?

Options
1_UTOPIAlk
1_UTOPIAlk ✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello, 

I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa").  The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75, "Syringa"), hence making the results wrong. 

 

I have been saving the formula, directly after entering it into the cell.  I have also locked the sheet summary cells so others cannot change them.   Can anyone advise how to correct this, or is this a bug?  

 

Thank you! 

Laura 

 

Comments