When I create a blank sheet to test the autofill formula feature, it works well. However, it does not seem to be working on my sheets that are project sheets.
Anyone have any insight on this?'
TIA
Hello Lisa—the autofill formula feature will only autofill when the same exact formula exists in 2 rows above, 2 rows below, or 1 row above and 1 row below—all on the same hierarchical level.
If your formula is slightly different, even in its pattern for referencing cells, or doesn't meet the above criteria, then it won't autofill.
Check out our Help Center article on autofill: http://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting
If you feel your formula meets all of the above conditions and still isn't autofilling, email Support@Smartsheet.com so they can get shared on the sheet and troubleshoot further.
