Apply formula to full column

Roland2023

As lines are constantly added in a workinglist, I want to ensure any new lines will always have a column with a formula filled in. The formula will check certain data in fields on that line to show a specific status/value.

I read that i should be able to 'insert' a formula on a full column, but can't find it. I'm only able to copy-paste the formula. Example where a new line is being added but the formula doesn't automatically apply/run on that line.

Capture.PNG

Razetto

@Roland2023 Hi, Try converting your formula to use @row references instead of to an specific one. =IF(ISDATE([launch]@row), IF(WEEKNUMBER([launch]@row)=.....

Roland2023

Thanks for the speedy response! Although the formula works, it only adds in on the single field and not across the full column. Could be my original question is a bit confusing, but i'm basically looking for a 'formula field' to be added. Example when I add the formula and all other fields in the column remain empty:

MichaelTCA

Hello @Roland2023

The @row is a generic reference specifically designed to be used in formula fields, but is also a convenient reference to use in all functions, especially when developing a sheet. Smartsheet calls these "column formulas".

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Right click on the cell that contains the formula. At the very bottom, you should be able to select the option to convert it to a column formula.

Roland2023

Awesome, adjusting it to 'row' and then use the right click in a field that contains the formula, showed me the option!