Formula Autofill Issue

I'm having an issue with autofilling formulas when I add new rows....

I have a sheet with some columns that contain formulas that only reference other cells contained within that row.

When I insert a new row and enter data into the primary column those formulas autofill into that new row like they are supposed to.

I have other columns that have formulas that contain references to particular cells in other rows. These formulas are not autofilling when I add new rows.

Is this a temporary glitch or a limitation of Smartsheet?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!