Automated workflow with Formula
i am trying to add a formula to a cell when a row is created or changed.
i have read almost everything and they say use a helper column, great, but i still have to copy the fomula to the newly added rows.
i trying to add this formula to a cell (Year column) on new rows, =IF([Request Date]@row <> "", YEAR([Request Date]@row), "").
any ideas or help?
Best Answer

Hello @Stephen Hindes
It sounds like the CONVERT TO COLUMN FORMULA will solve your problem. This can be found in the CELL menu. Rightclick on a cell that already contains the formula you want for the entire column. You'll find Convert to Column Formula at the very bottom of the menu. NOTE: remember once converted to a column formula you must go back into the cell menu to edit the formula.
You can find more information on Column Formulas here
Kelly
Answers

Hello @Stephen Hindes
It sounds like the CONVERT TO COLUMN FORMULA will solve your problem. This can be found in the CELL menu. Rightclick on a cell that already contains the formula you want for the entire column. You'll find Convert to Column Formula at the very bottom of the menu. NOTE: remember once converted to a column formula you must go back into the cell menu to edit the formula.
You can find more information on Column Formulas here
Kelly

that worked great, BIG thanks
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!