Self-populating formulas in rows

Staycie Francisco

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.

Kennedy Stomps

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!