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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 287 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!