Allow editing for cells in a formula column

As a work-around, you can create a helper column with a 'suggested' value, in your official column, you can either enter a value manually or write a 2-second equation that simply references the suggested value.

Eg. =[Suggested Value]@row

However, I currently have a need for this type of functionality. I want certain columns of new line entries to be automatically filled with a result of an equation and not the equation itself. Like a workflow that "Changes the value of a cell" when a "new line is added" but it doesn't just put in a fixed value (like it currently does) but uses the result of a formula that you enter.

I have many sheets that the parent rows are formula based but the child task need inputs from users.

Being able to have a column formula to say: If(this is the parent row, Sum(Children()), UserInput (let the user fill out the cell)) then parent rows will always do that formula & child rows can be filled out by users.

Another example is wanting the parent status to be based off the child tasks. Users need to update status at the child level & a formula is needed at the parent level. Example: If(this is the parent row, return the status based on formula, otherwise let the user set the status)

Currently the solution is to make helper columns or to copy the formulas manually.

Hi Nico,

It ends up costing a good amount of time as I have to teach all my teammates how to maintain the sheet. If this idea was in place, it would be very easy to onboard them to my sheets.

Take a budget sheet for example:

The goal of this sheet is for directors (who don't currently use smartsheets) to maintain budgets per period.

The flow is,

• They fill out a template form which then adds it to this sheet with the amount of child tasks they need.
• That copies to the main sheet where they rename the child tasks to different expense categories.

The parent line of each period is a sum of the child tasks & the user enters each expense category budget. For the picture below: the $310,000 is a formula SUM(CHILDREN()) & $100,000, $200,000, & $10,000 were manually entered.

I would love to set a column formula that says =IF(Parentlevel@row=1(top),SUM(CHILDREN()),USERINPUT)

Another example of this:

This is a screenshot from a sheet that has many projects on it & more are continuously added

The blue in progress is a formula checking:

• If all child tasks are complete - it's complete
• If all child tasks are not started - it's not started
• Otherwise it's In Progress

My team needs to enter the status of the children for all the projects but the parent will always be that formula.

This idea would make a column formula that says IF(Parentlevel=1(Top),use the formula, userinput)

@Nick055

Thank you for your feedback and elaboration. Do you have an action tracker in place to handle deviations?

I would recommend setting up the sheet differently, perhaps more like a structured table. From there, you could apply filters for each person, department, or current user to streamline visibility.

We’ve built similar KPI tracking systems for clients, monitoring weekly KPIs across six locations.

If you’d like, we can schedule a demo to show how it works.

A basic question to consider: What is the final goal? Is it a dashboard for visualizing data, tracking actions on deviations, or primarily data collection?

Or you use this :