Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Does the autofill formula feature not work on project sheets?

Lisa ✭✭✭
edited 12/09/19 in Archived 2016 Posts

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?'





  • 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.

This discussion has been closed.