Get protected with Column formulas.
Smartsheet have announced this handy new feature at SmartsheetEngage 2020.
You can now apply column formulas to your Smartsheet.
The feature is designed to set the formula for the whole column including new rows. It removes the need to drag a formula down, saving you time and effort.
Simply create the formula in one cell, then turn it into a column formula with a click of a button, and the entire column will fall into line. You have the assurance that your formula will always be present. It will remain locked in place, taking away the pain of editors changing it!
This is a great way to protect formulae from accidental deletion or editing by collaborators, ensuring that every row receives that function.
See how to use Column Formulas in sheets that use Row Hierarchy
And don’t forget, you can Subscribe to our regular Tips & Tricks and get alerted about our New Tips & Tricks Webinars.