Does the autofill formula feature not work on project sheets?

Lisa

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

Shaine Greenwood

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.