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.

How to autopopulate a column with formulas such that when a new line is inserted, it is automaticall

Christopher Grinde
Christopher Grinde ✭
edited 12/09/19 in Archived 2016 Posts

How to autopopulate a column with formulas such that when a new line is inserted, it is automatically filled in and calcuated?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Kara Lumley
    Kara Lumley Employee

    Hi Christopher,

    You'll see the formulas populate automatically when:

    • Typing into a newly inserted or a blank row directly in between two others that have the same formula applied.
    • Typing into a newly inserted row at the very top of the sheet, if it's above two others that have the same formula 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 formula applied. This includes rows inserted via web form.
    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories