Auto drag down TODAY formula

Natalie Caamano

Hello! I have a sheet with a column designated to always show the =TODAY(0) formula. However, I noticed that when new rows are added, I have to manually drag down the formula. Is there a way to auto-populate the column and lock it so each new row will always have this formula?

Thanks!

James Keuning

Convert it to a column formula?

David Fiorino

Put the formula in the cell of row 1 and hit enter, right-click to get the context menu to appear, and choose the last option to 'convert to column formula'. This should set the column up. Click the down arrow just above the first row (the narrow gray row above the header text row) and choose 'lock column' so only admin can change this. If you want to edit the cell formula you have to right-click the cell to edit the formula since it is a column formula.

James Keuning

Convert it to a column formula?

David Fiorino

Put the formula in the cell of row 1 and hit enter, right-click to get the context menu to appear, and choose the last option to 'convert to column formula'. This should set the column up. Click the down arrow just above the first row (the narrow gray row above the header text row) and choose 'lock column' so only admin can change this. If you want to edit the cell formula you have to right-click the cell to edit the formula since it is a column formula.

Natalie Caamano

Thank you both so much! Didn't know this was a capability in Smartsheet. Exactly what I needed.