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
 10.7K Get Help
 63 Global Discussions
 68 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!