How can I get a new row to populate with the format and formulas of the row above it?

Edwin Jr.

The rows will be children of a same group. I am trying to make a simple checkbook style sheet and I want users to be able to add rows and have the all the formulas and formatting iterate down.

From the above screenshot, I want the yellow fields to be added and the formula that subtracts the amount paid (yellow cells) from the budgeted amount (last column) from the row above it, automatically. I know it is a simple formula, but I am new to smart sheet and I am trying to make it easy for my team to adopt. Right now I am using a simple SUM formula to do it, but when I add a new row, I need to copy the formula and formatting down.

Thanks!

Andrée Starå

https://community.smartsheet.com/discussion/122281/how-can-i-get-a-new-row-to-populate-with-the-format-and-formulas-of-the-row-above-it

Hi,

I hope you're well and safe!

The new row will be auto-filled with the formulas if there are two rows below/above with the same formulas and the same level of hierarchy.

More details:
If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.
Conditions That Trigger Formula Autofill
You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

• Directly between two others that contain the same formula in adjacent cells.
• At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formulas.

More info: 

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment help or answer your question? Please support the Community and me by marking it 
💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!