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.

Self-populating formulas in rows

Why don't the formulas instantly populate the next row? This is extremely frustrating. Sometimes, the self-population or smart population of formulas will occur in proceeding rows, and the other times, it won't. Is there some sort of trick or process to make sure this happens every time? Thanks in advance for any help with this issue.

Tags:

Comments

  • Hi Staycie-- Formulas and formatting will auto-fill under the following conditions:

     

    • * Typing into a newly inserted or a blank row directly in between two others that have the same formatting applied.

    * Typing into a newly inserted row at the very top of the sheet, if it's above two others that have the same formatting applied. This includes rows inserted via web form.

    * Typing into a newly inserted or blank row at the very bottom of the sheet, if it's below two others that have the same formatting applied. This includes rows inserted via web form.

     

    If your sheets don't seem to be following these rules, please reach out to us at Support@Smartsheet.com to troubleshoot further!

     

This discussion has been closed.