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.
@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!
