Auto drag down TODAY formula
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 autopopulate the column and lock it so each new row will always have this formula?
Thanks!
Best Answers


Put the formula in the cell of row 1 and hit enter, rightclick 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 rightclick the cell to edit the formula since it is a column formula.
Answers


Put the formula in the cell of row 1 and hit enter, rightclick 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 rightclick the cell to edit the formula since it is a column formula.

Thank you both so much! Didn't know this was a capability in Smartsheet. Exactly what I needed.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!