How can I apply a formula to a whole column

TeeM

We have a webform populating a sheet. (See screenshot)

We have formulas set up on the additional 3 columns but they don't populate when the webform is submitted. At the moment, we have to drag the formulas manually. Is there a way I can apply the formula to the whole column?

Andrée Starå

Hi @TeeM

I hope you're well and safe!

You can probably use the Column Formula, but you'd need to structure the formula, so it works for all "levels".

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

TeeM

Thanks Andree, I will try that.👍️

TeeM

Ok... that seems to work ok but then I lose the SUM(CHILDREN) formula on the top row. Also the column formula does not seem to work on the 3rd column for some strange reason. This is what it looks like now after applying the column formula as suggested....

Andrée Starå

@TeeM

Happy to help!

That is why I mentioned the "levels!. You'll have to expand on the formulas, so it should do something else when it's a parent row.

Regarding the third column.

What's the formula?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

TeeM

=[ODOMETER STOP]@row - [ODOMETER START]@row

TeeM

How should I expand the formula for the parent row?

TeeM

Hello @Andrée Starå @Paul Newcome

Can either of you help here? Paul I think you had a similar request some time ago but I couldn't get the suggested solution to work. Glad if either or both of you could respond. Many thanks.