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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!