Column formulas apply to all the cells in that column, and they are a great way to automatically populate your table with information without having to remember to adjust your formula parameters.
Let's say you want to track end dates, and each end date is 3 days after the start date. You can write a column formula for the end date column that references the start date column.
First, create your start date column and then create the end date column - don't forget to choose the date format for both of these columns.
Now it's time to add your formula. You can do this one of two ways:
Click any cell in your End Date column and type = . This will bring up the formula editor, where you can type rest of your formula. Hit enter and your new end dates will automatically populate into your column. Any time you add a new row, this column will update as well!
Alternatively, you can click into the column header for the End Date column, then select Add formula from the drop-down. This will also bring up the formula editor.
If you like, you can use a column formula to work with multiple other columns. Let's say you want to know the total cost of an item which is made up of the list price and the tax. You can add those two columns together to get the total cost in the third column:
Note: you might notice the term thisRow in the formula examples above. If this is new to you, check out this article for more info.