Apply formula to full column
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 copypaste the formula. Example where a new line is being added but the formula doesn't automatically apply/run on that line.
Answers

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

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:

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".
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.

Awesome, adjusting it to 'row' and then use the right click in a field that contains the formula, showed me the option!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!