Autofill Formula
Hello,
I have two formulas set up that will display a value whenever a date is entered into the first cell of each row. That being said, sometimes the formulas won't work when a new value is entered. I've made sure the formula column is locked so user can't type information over the formula. I've also deleted the blank rows so the auto fill will copy the formula from the above rows. Is this something that other smartsheet users have experienced?
Thanks,
Miles
Best Answer

Hi Miles
Are you certain that your formula captures all types of valid entry? Could you paste a copy of the formula that isn't always working here?
Have you tried turning the formula into a Column Formula? (Right click and select Convert to Column Formula) This will ensure that the formula is definitely present in new rows.
I'd be happy to help further if needed.
Kind regards
Debbie
Answers

Hi Miles
Are you certain that your formula captures all types of valid entry? Could you paste a copy of the formula that isn't always working here?
Have you tried turning the formula into a Column Formula? (Right click and select Convert to Column Formula) This will ensure that the formula is definitely present in new rows.
I'd be happy to help further if needed.
Kind regards
Debbie

I didn't realize convert to column formula was an option. This helps a lot. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K 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
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!