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å

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

Edwin Jr.

May 21, 2024

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.

https://us.v-cdn.net/6031209/uploads/EYPA7DWKHPTQ/2024-05-21-smartsheet-001006.png

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!

---

View Post

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: 

Automatic Format and Formula Autofill | Smartsheet Learning Center

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!