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 copy-paste 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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!