How can I apply a formula to a whole column
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?
Answers

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".
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Thanks Andree, I will try that.👍️

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....

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

How should I expand the formula for the parent row?

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.
Help Article Resources
Categories
Check out the Formula Handbook template!