Automated workflow with Formula

Stephen Hindes

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?

Kelly Moore

Hello @Stephen Hindes

It sounds like the CONVERT TO COLUMN FORMULA will solve your problem. This can be found in the CELL menu. Right-click 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

Kelly Moore

Hello @Stephen Hindes

It sounds like the CONVERT TO COLUMN FORMULA will solve your problem. This can be found in the CELL menu. Right-click 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

Stephen Hindes

that worked great, BIG thanks